Full Version: Add 1 year to a date field to append to a new table ...
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
TheZjooj
Hello all,
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:
Expr1: MyDate+1
but that only increases it a day...
Any help would great!!
Thanks,
Zjooj
fkegley
Expr1: DateAdd("yyyy", MyDate,1)
freakazeud
The syntax is the other way around:
xpr1: DateAdd("yyyy", 1, MyDate)
thumbup.gif
TheZjooj
Perfect!! Thank you both!!!
freakazeud
You're welcome.
Glad we could assist.
Good luck on future projects!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.