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
CafeCafe 

Validation rule: close date must be after current date

I would like to make a validation rule that won't allow users to save their opportunity records if the close date is on or before the current date. This seems like it should be pretty straightforward, but I can't figure it out. Has anyone been able to do this? Thanks in advance if you have an answer for me!
Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

 

AND(NOT(IsClosed), CloseDate < TODAY())

 

 

All Answers

CafeCafe
I guess I asked too soon. I figured it out. Pretty simple:

Closedate < Today()
AidanFlynnAidanFlynn

I'm looking for one which is the same as this, but only applies it to open oppts. Any ideas?

 

Cheers,

 

Aidan
Steve :-/Steve :-/

 

AND(NOT(IsClosed), CloseDate < TODAY())

 

 

This was selected as the best answer
AidanFlynnAidanFlynn

Good stuff, thanks very much for a prompt response Stevemo!
Steve :-/Steve :-/

No problem, you owe me a beer!