+ Start a Discussion

Workflow to send a survey = today() - DATEVALUE(Last_Survey_Sent_Date__c) >= 90

I created a workflow formula to send a survey if Last Survey Sent Date is greater than or equal to 90 days. I need to also send the survey if there is no date in the field (as in the case of a new contact). 


Can anyone help me add to this formula?


Thanks in advance for your help!


today() - DATEVALUE(Last_Survey_Sent_Date__c) >= 90

I also need it to trigger on case closed. Thanks.
Naveen NelavelliNaveen Nelavelli

check out this

OR( today() - DATEVALUE(Last_Survey_Sent_Date__c) >= 90,isBlank(Last_Survey_Sent_Date__c))