Date Field Validation

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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
 
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?
 
Thanks, Sue. No, it wasn't intuitive, and we never would have figured it
out. Thanks again for the great info.

Sue Mosher said:
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?

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


Chris said:
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
Click to expand...
Click to expand...
 
Back
Top