Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

How can I do this? I have a field which contains a person's contract end date.

I can't use Evaluate This Rule When the Record is "created" - because it will never run again, after the record is first created. i.e. if the person's contract is extended.

I can't use "created, and every time it’s edited" because then I can't use time-dependent workflow actions i.e. my reminder email 45 days before end date.

And I can't do "created, and every time it’s edited" because it will only trigger the first time the criteria is met never again (if my criteria is "EndDate__c >= TODAY + 45").

Any ideas?

share|improve this question

2 Answers 2

up vote 6 down vote accepted

This is standard functionality. If the date used to calculate a time based workflow changes, the schedule time for the action will change accordingly.

From the knowledge article:

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

and the key text:

What happens if I update the value of a date field used in a time trigger?

If you update the date field used in a time trigger, Salesforce recalculates the time trigger as long as the time trigger has not yet fired and the recalculation does not reschedule the time trigger to a date in the past.

For example, if a workflow rule alerts the opportunity owner seven days before the opportunity close date and the close date is set to 2/20/2008, Salesforce sends the alert on 2/13/2008. If you update the close date to 2/10/2008 and the current date is 2/2/2008 or before, Salesforce reschedules the alert for 2/3/2008. The evaluation date of pending actions is ALWAYS reevaluated and updated if necessary irrespective of the rule criteria. Of course, if the rule is evaluated to false, it does not matter as the actions are removed from the queue.

share|improve this answer

Use

created, and any time it’s edited to subsequently meet criteria

When date field will be changed, also time of sending message will be changed.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com?utm_source=stackoverflow.com&amp;utm_medium=site-ui&amp;utm_campaign=footerlink\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.10.1.1906\r\n            </div>\r\n                <div id=\"additional-notices\">\r\n                    Salesforce is a registered trademark of salesforce.com, Inc.\r\n                </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warnin"], "copyright__copyright__copyright": ["rse, if the rule is evaluated to false, it does not matter as the actions are removed from the queue.\n\nshare|improve this answer\n\nUse\n\ncreated, and any time it\u2019s edited to subsequently meet criteria\n\nWhen date field will be changed, also time of sending message will be changed.\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}