I have a column validation being used for one of the Date Fields called Holiday Date. Below is the validation formula:
So i am only allowing users to enter the above two dates mentioned in the formula, if they enter anything else then it throws an error. The issue is, I have kept this field optional OOTB but because of column validation, if I leave it blank, it shows me the column validation error.
Is there anyway we can allow a date field to be left empty even if column validation is in use for the same or no?
Thanks in advance.