I guess you publish your article using apex class (maybe with scheduled class) so you can update the field from the class itself.
I assume your published date field API name is published_date__c and object variable name as article. article.published_date__c = article.published_date__c.addDays(90);
you can put it in a list and update if you publishing list of articles.
Hi Sami, more clarity given on question When knowledge article published the publish status equal to published. In that time published time need to reflect in custom field. Using workflow or formula is there any way?
you also need to save your published date and try this if(TEXT(Published_Status__c)=='Published', if(Published_Date__c<>null,Published_Date__c +90,null),null)
I guess you publish your article using apex class (maybe with scheduled class) so you can update the field from the class itself.
I assume your published date field API name is published_date__c and object variable name as article.
article.published_date__c = article.published_date__c.addDays(90);
you can put it in a list and update if you publishing list of articles.
Does it make sense?
more clarity given on question When knowledge article published the publish status equal to published. In that time published time need to reflect in custom field. Using workflow or formula is there any way?
Below is the example with workflow
If you wanna try formula field
you also need to save your published date and try this
if(TEXT(Published_Status__c)=='Published', if(Published_Date__c<>null,Published_Date__c +90,null),null)
Let me know it helps you.