You need to sign in to do that
Don't have an account?
Miguel Egas 7
Validation Rule for future date is not working
Hi Folks, I have the following validationformula that is supposed to prevent the creation of the record unless the criteria is met, however, after implementing the validation, the record still gets created if a choose a date in the past. For example if today is nov 13, and I chose Oct 20, the record should not be created. What am I doing wrong?
AND( WEEKDAY(Survey_Requested_Date__c) <> 2, /* Not Monday */ WEEKDAY(Survey_Requested_Date__c) <> 6, /* Not Friday */ Survey_Requested_Date__c >= TODAY() /* Date is in the future */ )
Th pipes || are an OR statement, thus the second condition for AND includes and OR.
All Answers
Th pipes || are an OR statement, thus the second condition for AND includes and OR.