Data validation for input of date in the form of dd/mm/yyyy

Crymm9

Guest

Posts: n/a

27th Jan 2010

Hi,
I am trying to create a validation for a date field in Tanzania. They input
the day first. In my Input mask I have:
!00\/00\/0000;0;#

In my validation rule I have:
Like "[0-3][0-9][0-1][0-9][1-2][0-9][0-9][0-9]"

this should keep most of the bad data out, but access doesn't accept the
first number as zero. It will validate if it is over 4 and all the other
numbers are validated correctly.

Help,
Lisa

« I have two Yes/No fields in a table (ContractorInstall, andInHouseInstall) | Tables & Relationships »

Thread Tools
Show Printable Version Email this Page
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 BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation: want input restricted to date value or N/A	Rachel Garrett	Microsoft Excel Worksheet Functions	2	11th Jun 2008 07:37 PM
Adding 1 year's difference to user's input of yyyy-yyyy?	StargateFanFromWork	Microsoft Excel Discussion	3	29th May 2007 05:25 PM
data validation on form involving date control	=?Utf-8?B?VGVk?=	Microsoft Access Getting Started	7	8th Dec 2005 02:31 PM
How to set up input mask for an international date - dd/mm/yyyy?	=?Utf-8?B?TGVzbGVl?=	Microsoft Access Forms	2	19th May 2005 04:35 PM
input mask Need DATE/TIME field to = MM/YYYY	=?Utf-8?B?VGluYWRhd24=?=	Microsoft Access	1	29th Nov 2004 10:31 PM