Date range too high 01/01/2030

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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>
 
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.
 
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.
 
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
 
Back
Top