Input mask for date!

Joined
Sep 28, 2011
Messages
1
Reaction score
0
Hi,

I'm trying to change the input mask in Access 2003 for date so that it supports more than one functionality.

For example :
* When I store the date with input mask : 99/00/00; it allows me to enter date only as 08/11/11 and stores it as 08/11/2011.
* When I store the date with input mask : 99/00/0000; it allows me to enter date only as 08/11/2011 and stores it as 08/11/2011.

However if I enter the date as 08/11/11, I need it to be stored as 08/11/11 itself. Similarly in case of 08/11/2011.

Can someone please tell me the input mask suitable for this?

Thanks
Justin
 
Back
Top