Date Field Validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 28 Mar 2008 21:45 GMT

A co-worker has date fields on a message form created in Outlook 2003 for
employees to enter hours. The date must be a Sunday, and it should not be
null. (Weekday( [Wk 1 Ending Date] ) =1) AND ([Wk 1 Ending Date] <>"")
don't seem to work. Any suggestions would be greatly appreciated. Thanks.

Chris

Reply to this Message

Sue Mosher [MVP-Outlook] - 30 Mar 2008 02:27 GMT

If you tested each validation expression separately, you'd find out that the first expression works fine and that the problem is with the second one. The field must be <> "None" not "". Not intuitive, given that it's a date field, is it?

Signature

Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

>A co-worker has date fields on a message form created in Outlook 2003 for
> employees to enter hours. The date must be a Sunday, and it should not be
> null. (Weekday( [Wk 1 Ending Date] ) =1) AND ([Wk 1 Ending Date] <>"")
> don't seem to work. Any suggestions would be greatly appreciated. Thanks.
>
> Chris

Reply to this Message

Chris - 30 Mar 2008 19:00 GMT

Thanks, Sue. No, it wasn't intuitive, and we never would have figured it
out. Thanks again for the great info.

> If you tested each validation expression separately, you'd find out that the first expression works fine and that the problem is with the second one. The field must be <> "None" not "". Not intuitive, given that it's a date field, is it?
>
[quoted text clipped - 4 lines]
> >
> > Chris

Reply to this Message

Rate this thread: