PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Form Programming Date validation

Reply

Date validation

 
Thread Tools Rate Thread
Old 10-07-2003, 08:33 AM   #1
Andy
Guest
 
Posts: n/a
Default Date validation


I want to check that a field entered is a monday, by entering
something in the validation tab of the field. Not sure how to do it.
The field is called Week Commencing.


Thanks in advance for any help
  Reply With Quote
Old 10-07-2003, 02:56 PM   #2
Natarajan
Guest
 
Posts: n/a
Default Re: Date validation

Use
Weekday([week commencing])=2

in the validation tab.

Regards
Natarajan

andrew_hibbert@hotmail.com (Andy) wrote in message news:<e4d403cb.0307100033.17f5d70d@posting.google.com>...
> I want to check that a field entered is a monday, by entering
> something in the validation tab of the field. Not sure how to do it.
> The field is called Week Commencing.
>
>
> Thanks in advance for any help

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off