I have set a validation rule on the open date field that
Open_date__c < today().
my query is whenever I edit the record it tells me to change the date to today or it will not save.
what I want is that whenever I edit it should not ask me to change the date to today. It should remain the original created date
what formula should I use?
답변 4개
ok - so your valdiation rule should be:
OR(
AND( ISNEW(),open_date__c<today()),
ISCHANGED( open_date__c )
)
syntax explanation :
your rule evaluates to true if one of the following is true:
(record is new AND open date before today)
OR
(record exists & open_Date__c has changed)
