Changing mm/dd/yy format to mm/dd/yyyy

P

Pamela

How can I allow the db user to input a date with the year as a 2 digit
format, for example 07/16/08, and have the system convert it to 7/16/2008?
I've tried with input masks but can't seem to make it work. Thanks!!
 
D

Douglas J. Steele

As long as Access recognizes the date correctly, it really doesn't matter if
the user uses a 2 digit or 4 digit year: it's going to be stored the same
way internally. (Behind the scenes, dates are 8 byte floating point numbers,
where the integer portion is the date measured as the number of days
relative to 30 Dec, 1899, and the decimal portion is the time measured as a
fraction of a day)

All you need to do is ensure that the format is set how you want it: nothing
to do with input masks.
 

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

Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
Change MM/DD/YYYY to MM/DD/YY 5
dd/mm/yy format on textbox 10
MM/YYYY Input format 2
Got dates in dd/mm/yy, Excel refuses to understand this 1
Access 2003 Date Input problem 3
Converting MM/DD/YYYY into just MM/DD and Sorting 1

Top