function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jjjjjjjjjjjjjjjjjjjjjjjjjjjjjj 

Capturing the last modified date for an Opportunity

Hi,
 
I am trying create a formula under work flow rule such that "if last modified date for an Opportunity is more than 31 days then an email is sent to the account owner" . Now I do not see any field to capture the last modified date in opportunity. There is Only one field ie "Last modified by" which captures the name of the user who last modified the Opp with the date/time. I wrote the following formula:
 
AND(DATE (YEAR(DATEVALUE(LastModifiedDate)),MONTH(DATEVALUE(LastModifiedDate)),DAY(DATEVALUE(LastModifiedDate)))<= TODAY()-31,ISPICKVAL(StageName,"100%-Contract Signed")<>True,ISPICKVAL(StageName,"100%-Sales Acct. Approved")<>True,ISPICKVAL(StageName,"Closed-Lost")<>True)
 
then ,
 
Trigger  an email to myself ( I am trying to test) .
 
There are no syntax errors for the formula. but still I do not see any emails in mailbox :( . Can someone help?