function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
suresh.csksuresh.csk 

Does Date arithmetic functions work in Time Dependent Workflow

AND (
Effective_End_Date__c >= Effective_Start_Date__c ,
(Effective_Start_Date__c - today()) == 1
)

The above rule is not firing.
Will the below code works in workflow 
Effective_Start_Date__c - today()) == 1 
Satish_SFDCSatish_SFDC
Yes, that should work. 
But i woild suggest you create a test formula field to check the value of the date arithmetic expression to check whether the value is what you expect. 

Regards,
Satish
suresh.csksuresh.csk
Thanks for your time.

It works in Formula but the below Time-Dependent Workflow Actions is not fired,any idea ?

Workflow rule:
AND (
Effective_End_Date__c >= Effective_Start_Date__c ,
(Effective_Start_Date__c - today()) == 1
)

Time-Dependent Workflow Actions:
1 Day After Product: Effective_Start_Date__c

Best Regards
suresh
Venkat PolisettiVenkat Polisetti
@suresh.csk,

That depends on the evaluation criteria.

If you set it ot "On create only" and your filter matches the conditions, then it adds the time based action to the queue. If the record is modified subsequently and the filter is no longer valid then it would remove the time base actions from queue. This would happen only once for "On create only" criteria and SF would not look at this rule again.

If you sent the evaluation criteria to "did not previously meet the rule criteria", then it would evaluate the filter whenever the record is changed if did not meet the criterial earlier and it would add/remove the queued items depending on your filter outcome.

Please read the FAQ in its enterity at the following link. I believe, it would help you to understand what is going on with your rule.

https://help.salesforce.com/HTViewSolution?id=000005245&language=en_US

Thanks,
Venkat
suresh.csksuresh.csk
Dear Venkat.

Thanks your great time and reply.
I understood well.

I had misunderstanding that the workflow will work whenever the conditions meets regardless of creation or editing the record.
I thought the SFDC will check the workflow rules everyday and run the workflow whenever the conditions are meet.

Moreover Effective_Start_Date__c - today()) == 1 is a bad condition.
Instead of the above
 
Workflow rule:
AND (
Effective_End_Date__c >= Effective_Start_Date__c ,
(Effective_Start_Date__c  >today))

Time-Dependent Workflow Actions:
1 Day After Product: Effective_Previous_Date__c


Effective_Previous_Date__c is a formula field which holds the the previous date of Effective_Start_Date__c.



Best Regards
suresh