year conversion in date fields eg 1900 to 2000

[alex]

I moved a existing database from foxpro to access 2000.
The dates in foxpro had a 2 digit year and when brought in
to access it converted them to 1900 (eg. 11/12/00 to
11/12/1900 instead of 11/12/2000). Is there a way in
access to convert (replace) only the year of vaious dates
to another year. If this is not possible is there a way to
prevent this while converting?

thanks alex

 

[Ken Snell]

An update query can work for this.

Something like this:

UPDATE TableName SET [DateFieldName] =
DateAdd("yyyy", 100, [DateFieldName])
WHERE Year([DateFieldName]) = 1900;