Access 05 showing up as 1905 Question

#1

I have an Access database that makes the date xx/xx/05 as xx/xx/1905
instead of 2005. For the past four years, the 00, 01, 02, 03, & 04 has
shows up as 20xx. Any idea on how to fix this? Or why all of a sudden
05 would show up as 1905 instead of 2005? Thank you for any help.

#2

john_20_28_2000 (AT) yahoo (DOT) com wrote:

Quote:

I have an Access database that makes the date xx/xx/05 as xx/xx/1905
instead of 2005. For the past four years, the 00, 01, 02, 03, & 04
has shows up as 20xx. Any idea on how to fix this? Or why all of a
sudden 05 would show up as 1905 instead of 2005? Thank you for any
help.

This is controlled in your Windows Regional Settings. The default is that
any two digit year that is from 00 to 29 is treated as a year beginning with
20 and anything larger than 29 is treated as a year beginnig with 19.

Somewhere along the line your settings must have gotten changed.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

#3

Exactly...Worked...Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access 05 showing up as 1905 Question

comp.databases.ms-access comp.databases.ms-access

Access 05 showing up as 1905 Question - 01-04-2005 , 08:26 AM

Re: Access 05 showing up as 1905 Question - 01-04-2005 , 09:53 AM

Re: Access 05 showing up as 1905 Question - 01-04-2005 , 10:59 AM