function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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)))




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


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.


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