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