Incorrect Year Format When Importing 1

[mizenerman]

This is an odd question and it may be glaringly obvious to someone more experienced than myself.

I'm importing a .csv file into a table. There is a DOB field in the .csv file that is formatted as mm/dd/yy. The format of the DOB field in the table is mm/dd/yyyy. In viewing the records after the import I discovered that ONLY the DOBs that end in the 1920's are have a prefix of 20 instead of 19. For example:

03/03/1927 = 03/03/2027.

Weird huh? How is this happening and more importantly how do I stop it from occurring?

 

[dhookom]

This is based on the settings in your Windows Control Panel under regional setting or something.

Duane
Hook'D on Access
MS Access MVP

 

[mizenerman]

Duane,

That was it! In the Regional and Language Options of the Control Panel there was a setting called:

When a two digit year is entered, interpret it as a year between: (Year) and (Year)

My settings were between 1930 and 2029. I changed the settings to be between 1915 and and 2014 and the DOB field is now using the correct year!

I was using a DateDiff expression to find the patients age and when the DOB was in the wrong year the age reflected a negative number. Thanks again!