|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
March 28th 08, 08:45 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Date Field Validation
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 
|
| Ads |
|
#2
March 30th 08, 02:27 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Date Field Validation
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" wrote in message ... 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
|
|
#3
March 30th 08, 07:00 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Date Field Validation
Thanks, Sue. No, it wasn't intuitive, and we never would have figured it
out. Thanks again for the great info. "Sue Mosher [MVP-Outlook]" wrote: 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" wrote in message ... 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Julian Date Field | Tom Conrad | Outlook - Calandaring | 2 | July 23rd 07 03:26 AM |
| Date field | prog | Outlook - Using Forms | 2 | May 17th 07 02:47 PM |
| date field behaviour | Long Nguyen | Outlook - Using Forms | 3 | April 13th 06 02:37 AM |
| date field in outlook | [email protected] | Outlook - Using Forms | 4 | February 23rd 06 06:37 PM |
| date fields - link the calander pop-up to a custom date field | Tom | Outlook - Using Forms | 0 | January 23rd 06 09:13 PM |
Linear Mode
