change dates in access

[Guest]

It was necessary to transfer our database from DOS to Access. I have noticed
since doing so that the years are incorrect in the dates. eg 12/01/1905
should be 12/01/2005. How can I change the year automatically from 1905 to
2005 or do I have to do it individually?

 

[Allen Browne]

Use an Update query to add 100 years to the dates before 1930 (or whatever
cut-off you want to use.)

1. Create a query using this table.

2. Drag the date field into the grid.
In the criteria row under the field, enter:
< #1/1/1930#

3. Change it to an Update query. (Update on Query menu.)
Access adds an Update row to the grid.

4. In the update row under the date field, enter:
DateAdd("yyyy", 100, [Date1])
substituting the name of your field for Date1.

5. Run the query.