You need to sign in to do that
Don't have an account?
kim_lebicz
Validation Rule Question
Hello All
I am trying to create a validation rule that says:
If Date_c Today or is null and Service_c is true error is triggered. This is the formula but it doesn't work if the date field is null.
AND( Date__c TODAY(), Service__c, true)
Any help would be appreciated.
I am trying to create a validation rule that says:
If Date_c Today or is null and Service_c is true error is triggered. This is the formula but it doesn't work if the date field is null.
AND( Date__c TODAY(), Service__c, true)
Any help would be appreciated.
I assume Service__c is a checkbox. This validation rule should do the trick.
AND(
OR(Date__c = TODAY(), ISNULL(Date__c)),
Service__c
)
Hope that helps,
Eric