Changing years

[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?

 

[Allen Browne]

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.

 

[Arvin Meyer]

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