Add one year to date/time field

[PaultheS]

I'm looking to run an update query in MS Access that will take an existing Date/Time field and add one year to it. I was looking at the DateSerial function but I believe that would get rid of the times and I need those to stay the same. Any thoughts?

 

[PHV]

And what about the DateAdd function ?
UPDATE myTable SET [DateTime field]=DateAdd('yyyy',1,[DateTime field]) WHERE ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886