Month Function needed??
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)
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