Short Date Entries

[Guest]

When I enter a date prior to 1930, (for instance 12/12/1929), the date shows
as 12/12/2029)
What do I need to change to make the data read 12/12/1929?

 

[John W. Vinson]

When I enter a date prior to 1930, (for instance 12/12/1929), the date shows
as 12/12/2029)
What do I need to change to make the data read 12/12/1929?

How do you want 12/12/2007 to be displayed? How about 12/12/1907?

If your dates span a human lifetime, you MUST use four digit years. I know
people born in '04 and also other people born in '04... some are in baby
strollers and some are in assisted-living old folks' homes.

Access by default treats two digit years from 00 through 29 as being in the
21st century, 30 through 99 as being in the 20th. This is controlled, not in
Access, but in your Windows settings: see

http://office.microsoft.com/en-us/access/HA010345721033.aspx?pid=CL100570041033


John W. Vinson [MVP]

 

[Guest]

Thanks, John. Really appreciate your help.

narfla