Update query to add +1 to date?

[rhett7660]

Hi all..

When I brought in a table from excel to access...all the dates were off by one day. I have tried to do an update query to add +1 day to all the dates..but it hasn't work..

I have tried this: DateAdd("dd",1[DateOverpaymentBegan]) but I am getting an expression error..

I have done a search of the forum (that is where I found the above expression).....but have not had any luck...

How can I add just one day to all the dates..?

Thanks
R~

 

[Michael J Ross]

Try:
DateAdd("d",1,[DateOverpaymentBegan])

 

[rhett7660]

Man that was too easy... Thank you very much worked like a charm..

R~