Input mask for date!

J

justin88

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access General Date Forced To Have Date And Time 2
Allocate an income payment over a date range (tax years) 7
Access 2003 Date Input problem 3
Calculating occupational sick pay entitlement 0
Add Hours by Looping through Data Q 27
Date Diff Issue 4
long date format for report input mask 1
Date Mask auto changes 1916 to 2016 2

Top