Date range too high 01/01/2030

J

Janis in Minnesota

Our database uses an end date past the year 2030 and when we try to input any
date in the field it changes it to the 1900's. For example: 01/01/2030
changes the date to 1/1/1930. Yikes! Help!!! :)
Thanks!!!!

Janis
 
D

Dirk Goldgar

Janis in Minnesota said:
Our database uses an end date past the year 2030 and when we try to
input any date in the field it changes it to the 1900's. For
example: 01/01/2030 changes the date to 1/1/1930. Yikes! Help!!!
Click to expand...

Are you sure you aren't actually entering a two-digit year: "1/1/30" ?
From the help file:

<quote>
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).

</quote>
 
D

Douglas J. Steele

Dirk Goldgar said:
Are you sure you aren't actually entering a two-digit year: "1/1/30" ?
From the help file:

<quote>
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).

</quote>
Click to expand...

Actually, I believe that setting is user-selectable (at least in WinXP) on
the Date tab in Regional Settings in the Control Panel.
 
D

Dirk Goldgar

Douglas J. Steele said:
Actually, I believe that setting is user-selectable (at least in
WinXP) on the Date tab in Regional Settings in the Control Panel.
Click to expand...

Could be. The setting is there in Win2K, also. I don't actually know
whether Access observes this or not -- it's possible, though unlikely,
that it just does its own thing.
 
J

Janis in Minnesota

I actually changed the settings in both the Regional Date setting in the
control panel of each pc as well as in the database - I changed the date
field to general date. I should be set from either angle.

Thanks much!

Janis
 
Top