date edits

  • Thread starter Thread starter BkMark
  • Start date Start date
B

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
 
Try this variation:

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