Skip to main content
Topics#Data ManagementSara Monksfield's Question
Sara Monksfield (RSC) asked in #Data Management
May 22, 2019, 9:40 AM

Notification when Opportunity date changes from another value - how to stop this firing on first entry?

What's the formula to send an email when a date field is changed from one date to another, but not when the field is first entered (i.e. changed from blank to not blank)?

 

I've tried this but it still fires the email when you first populate the date:

 

AND(

 

NOT (ISNEW ()),

 

ISCHANGED(([Opportunity].Requested_Trial_Start_Date__c )))

 

 
10 answers
  1. Amnon Kruvi (The Architech Club)
    May 22, 2019, 10:14 AM
    Hi Sara, 

     

    Let's try this:

    AND(
    NOT (ISBLANK (PRIORVALUE([Opportunity].Requested_Trial_Start_Date__c ))),
    ISCHANGED(([Opportunity].Requested_Trial_Start_Date__c )))

     

     
Write an answer...
0/9000