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
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