Time based Workflow
I have a requirement to send out Email notification to an user if the opportunity sales stage remains as Inquiry and has not been modified in the last 90 days. Here's what I tried
Opp Name - Opp Sales Stage Clsure
Trigger:When Modified Record Saved
Workflow condition: <SalesStage> = "Inquiry"
Wait - time Expression: LastUpdated + 90
Send Email
The problem with this workfow is after waiting for 90 days, it will not check if the record was modified during the wait time and would still send a notification. I do not want to send an email notification if something was modified on the record. So on the other hand if I have the check in the workflow condition as<SalesStage> = "Inquiry" and today()-LastUpdated > 90, then the condition will be false for all the records that are modified in less than 90 days and the work flow will not reevalute to send notification.For Ex Record Creation Date: 3/4/2012 Record Modification