Help with Y2K dates

[626]

I recieve txt file data and import for an outside company that has a legacy system, there Y2K fix was to make the dates look like this: 202/1/1 (y/m/d)and add 1800 to the year. Does anyone know away I query or any other process so I can add 1800 to the date format above so I get the date to 2002/1/1, once I start building reports from the data the date layout my confuse end-users?


Thanks alot.

 

[cmmrfrds]

Why don't you just run a query after the import and add the 1800. Assuming the field is defined as datetime.

look up the syntax for dateadd, I believe it is as follows.

update table
set thedate = dateadd('y',1800,thedate)
from table