Re: Date changing 2028....2029......1930???????

Tech-Archive recommends: Fix windows errors by optimizing your registry

evilcowstare via AccessMonster.com wrote:
Hello!

I have a slight problem, in my form i have a date section which is
automated as 00/00/00. I use these for part of a report as a from
this date to this date, if you put 010125 it will automatically
change it to 01/01/2025. The thing I have found is that it is fine
until you get to 010130 and then it saves it as 01/01/1930 :-/
any ideas?

Thank You
Jay

That is the curse of using two digit years (remember Y2K?). In your Windows
Control Panel Regional settings there is a setting that determines what 2
digit value represents the cross-over value for assuming "19" as the first
two digits versus "20". You can teak that if your app will never be used on
any other PC. Otherwise the *correct* thing to do is to use a four digit
year.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.