I am trying to create a workflow to send reminder e-mails to users about stale cases. Essentially, the logic of the workflow is:
Execute on record (case) creation
Wait 24 hours
If Case is 'Active' Continue, Else Stop Workflow
If Case is 'Older than 14 days' send reminder e-mail and spawn new instance of this workflow, Else Spawn new instance of this workflow.
The problem I am having is 'Cases Older than 14 Days'. There seems to be no way to specify the current date in the condition criteria, and therefore no way for CRM to calculate 14 days after the 'Created on' date.
Does anyone have a suggestion on how to build this workflow?