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
kim_lebiczkim_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.
EricBEricB
Hi Kim,
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
kim_lebiczkim_lebicz
Thanks so much Eric!