Aug 28 2007, 12:22 PM
It's been a while since I have used access...
Could anyone help me with trying to figure out how to add a year to a date field in an append query so
that it appends the new record with the next year?
I was trying:
but that only increases it a day...
Any help would great!!
Aug 28 2007, 12:23 PM
Expr1: DateAdd("yyyy", MyDate,1)
Aug 28 2007, 12:32 PM
The syntax is the other way around:
xpr1: DateAdd("yyyy", 1, MyDate)
Aug 28 2007, 01:57 PM
Perfect!! Thank you both!!!
Aug 28 2007, 02:07 PM
Glad we could assist.
Good luck on future projects!
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here