Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incorrect Year Format When Importing 1

Status
Not open for further replies.
Joined
Mar 9, 2007
Messages
48
Location
US
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?
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top