date edits

[BkMark]

I have a situation where our employees will be entering up to 5 dates on an
outlook form. It is optional for them to enter all of the dates. But, if
they do, it must be a Monday date. I can get the check for Monday to work,
but if the date field is left blank, it still gives the error that it failed
the validation. I used the following for verifying the date (Weekday(date1) =
2) or (date1 ="None"). I also tried checking the date for: "", " ", and the
Outlook default date. None of which worked. Can anyone tell me what I am
doing wrong, please.

Thanks.

BkMark

 

[Sue Mosher [MVP-Outlook]]

Try this variation:

([date1] ="None") OR (Weekday( [date1] , 1 ) = 2)