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
KIBLKIBL 

Validation Rule

I am trying to create a validation rule that will not allow you to Save a case when the Follow Up date is past due.  I do want it to allow you to Close the case even though the follow up date is past due.  Here is what I have so far that is not working:

 

AND (Required_Response_Date__c  < TODAY (), NOT (ISPICKVAL (Status, "Closed)))

 

 

hisrinuhisrinu

AND (Required_Response_Date__c  < TODAY (),  ISPICKVAL (Status, 'Closed'))
KIBLKIBL

This stops me when the Status is closed but I don't want it to.  I want it to stop me for all other status except closed.
hisrinuhisrinu

AND (Required_Response_Date__c  < TODAY (), ISCHANGE(status), Not ISPICKVAL (Status, 'Closed'))