Changing years

  • Thread starter Thread starter John
  • Start date Start date
J

John

When I import data from a text file, sometimes the year
gets converted to future years (i.e. 1929 becomes 2029).
How can I stop this?
 
Open the Windows Control Panel | Regional Settings.
You can define how 2 digit years are to be interpreted.

In WinXP, it's under Regional Options | Customize | Date | Calendar.
 
This is really a Windows question, but ...

Microsoft uses an algorithm called windowing to set date values. By default,
all 2 digit dates <= 29 open as 2000, and all dates after 2029 open as 1900.

It is adjustable in control panel regional settings. Open Control Panel,
then Regional Settings, then the Regional Options tab, then the Date tab and
change the settings.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top