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

  • Thread starter Thread starter Pamela
  • Start date Start date
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!!
 
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.
 
Back
Top