My company has just started using Contracts. I created a value in the Status picklist called Expired for expired contracts. My goal is to automate setting the value to Expired without asking the sales reps to do this.
I am trying to accomplish this with a time based workflow rule. The logic I am using is:
1- Evaluation Criteria: Evaluate the rule when a record is created, and any time it's edited to subsequently meet criteria Description
2- Rule Criteria: Contract: Contract End Date NOT EQUAL to null
3- Time Trigger: 0 Hours after Contract: Contract End Date
4- Workflow Action: Field Update on Contract Status to Expired
However, this does not seem to be working. Is there something I am missing? Or should I be using a different method than workflow?
Thank you all so much!