Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
smitha vikramsmitha vikram 

how to set the Process builder formula for greater than date

I have the following formula in the process builder, however the date conditon is not working ie: if the date is greater than 60 days i am not getting the field update? how do correctthat
AND(

IF(NOT(ISBLANK([CampaignMember].ContactId )),TRUE,FALSE), 

IF([CampaignMember].Contact.HasOptedOutOfEmail==FALSE,TRUE,FALSE),

IF(NOT(ISBLANK([CampaignMember].Contact.AccountId)), true, false),

 CASE([CampaignMember].Contact.Account.Licensed_Mainframe__c,"Active", 1,0)=1, 

IF(ISBLANK( [CampaignMember].Contact.Last_Survey_Sent_Date__c)|| 

[CampaignMember].Contact.Last_Survey_Sent_Date__c >=today()-60, true, false)
Sunil RathoreSunil Rathore
Hi Smitha,

Greetings to you!!

To use the condition for the date is greater than 60 days from today's date you have to use today() + 60. The today()-60 will check for the 60 days before today's date.

Considering all the other conditions are correct. Please refer the below formula: 
IF(NOT(ISBLANK([CampaignMember].ContactId )),TRUE,FALSE), 

IF([CampaignMember].Contact.HasOptedOutOfEmail==FALSE,TRUE,FALSE),

IF(NOT(ISBLANK([CampaignMember].Contact.AccountId)), true, false),

 CASE([CampaignMember].Contact.Account.Licensed_Mainframe__c,"Active", 1,0)=1, 

IF(ISBLANK( [CampaignMember].Contact.Last_Survey_Sent_Date__c)|| 

[CampaignMember].Contact.Last_Survey_Sent_Date__c >=today() + 60, true, false)

Hope this will help you. If does then mark it as the best answer so it can also help others in the future.

Many Thanks,
Sunil Rathore