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?