Date defaults to 1900

[Jean]

My co-worker and I both use Access 2002. When I open the
database and type a date (i.e. 6/21), it will fill in with
6/21/2004. When my co-worker open the exact same database
and types 6/21, she gets 5/21/1904. Any suggestions??
Thanks.

 

[Robert Allyn]

Check the computer's date to see if it is wrong.

 

[Jean]

We did check that already...I'm sorry that I didn't
mention that. The computer's date and time are fine.

 

[Dirk Goldgar]

My co-worker and I both use Access 2002. When I open the
database and type a date (i.e. 6/21), it will fill in with
6/21/2004. When my co-worker open the exact same database
and types 6/21, she gets 5/21/1904. Any suggestions??
Thanks.

Are you sure she gets 5/21/1904, and not 6/21/1904?

 

[Robert Allyn]

What operating systems are you running on? I bet they are different.
I seem to remember some info on how the dates are handled in the OS,
and how it can be changed, but I don't have it now. I think you
should look for a diffence in the OS date setup, or registry settings.

 

[Jean]

Same operating systems too...Windows 2000 Professional.
What's even more curious is that it is ONLY this one
database file where the dates act differently on the two
computers that are imaged the same. With any other Access
file, the dates on both systems default to the year 2000.
Very weird and getting weirder all the time!

 

[DS]

Take a look at the Date tab in Regional Options in Control
Panel. My guess is that the two computers have their
Calendar | "When a two digit is entered, interpret as a
year between" settings are different.

This goes back to the old Y2K issues. A number of apps
(and Windows itself) kinda put off the issue my using what
some call a "Pivot Year".

If you'll look at the "Format Property - Date/Time Data
Type" article in the Help, you'll find a paragraph that
states

"Warning The Short Date setting assumes that dates
between 1/1/00 and 12/31/29 are twenty-first century dates
(that is, the years are assumed to be 2000 to 2029). Dates
between 1/1/30 and 12/31/99 are assumed to be twentieth
century dates (that is, the years are assumed to be 1930
to 1999)."

Personally, I avoid the whole issue by ALWAY forcing my
users to enter a 4 digit year. Otherwise, you're
vulnerable to what ever quirks they have on their local
PC's Regional Settings.

Hope that helps!

DS

 

[Robert Allyn]

check Control Panel | Regional Options | Date tab

Here is where the 2 digit year split is set.