Hi, Everyone

I have an Access database linked tables to our main server (Dbase system), recently, we transfer data into the new system, the server date wrongly set one month behind, so all DATE field data is now one month wrong. I would like to update to the correct date, should be one month ahead.

Here some examples:

Wrong Date corrected Date (should be)

28/02/2004 28/03/2004
25/12/2003 25/01/2004
30/05/2003 30/06/2003

and so on...

I would like to find out is there any function to add one month(NOT 30days) to the field, can anyone help?

Thanks in advance

Peter

take a look at the DateAdd function, example
UPDATE yourtable
SET thedatefield = DateAdd("m", 1, thedatefield)

Thank you very much, it works very nicely.

peter