Converting 97 to 2002

[Dale]

I converted a 97 database to Access 2002, but discovered that some dates were corrupted. Any date
that were supposed to be 2030 or later were displayed as 1930, etc. and some didn't display properl
(i.e. /25/2025). Any fix for this other than re-typing all those dates affected

 

[Allen Browne]

The dates would have been wrong in A97 also.
You could use an Update query to fix them.

1. Create a query into this table.

2. Drag the date field into the grid.

3. In the Criteria row under this field, enter:
< #1/1/1930#

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

5. In the Update row under the date field, enter:
DateAdd("yyyy", 100, [MyDate])
substituting the name of your date field for "MyDate".

6. Run the query.

This adds 100 years to all values earlier than 1930.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I converted a 97 database to Access 2002, but discovered that some dates were corrupted. Any dates
that were supposed to be 2030 or later were displayed as 1930, etc. and some didn't display properly
(i.e. /25/2025). Any fix for this other than re-typing all those dates

affected?