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:

Expr1: 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.