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
CarrieLeeCarrieLee 

Work Flow Rule Causing Issue

We are using a Work Flow rules that forces an update of the Opportunity Close Date if it is less than or equal to today's date.
 
CloseDate  <=  TODAY()
 
We have created a section in the Opportunity called Order Book.
 
During the sales process and after there is information in the Order Book that needs to be entered and or updated. The Work Flow rule requires us to move the Close Date forward even after the Opportunity has been changed to Closed Won. To keep Opportunity information accurate we don't want to keep moving the date forward not to mention it's a hassle. I keep getting a syntax error in this formula, any suggestions?
 
CloseDate  <=  TODAY()  AND Stage < ClosedWon 
 
Error: Syntax error. Extra AND
 
JakesterJakester
That's not how And() works in Salesforce - it works like this:
Code:
And( CloseDate  <=  TODAY()
    ,Stage < ClosedWon 
)