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
JJenkinsJJenkins 

Close Date cannot be in Past only if Opportunity is Open

I am trying to create a validation rule where the close date is required to be in the future, or not in past, if the opportunity is open.  Once closed won or lost I do not want the rule to be in place.

 

I've tried to do this off of type, stage and forecast category but I am having no luck.

 

Thanks,

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/
Is this what you're looking for?
AND( 
NOT( IsClosed ), 
CloseDate < TODAY ())
 


All Answers
Steve :-/Steve :-/
Is this what you're looking for?
AND( 
NOT( IsClosed ), 
CloseDate < TODAY ())
 
This was selected as the best answer
JJenkinsJJenkins
that worked! thanks so much