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 sothat it appends the new record with the next year?I was trying:Expr1: MyDate+1but that only increases it a day...Any help would great!!Thanks,Zjooj

fkegley

Aug 28 2007, 12:23 PM

Expr1: DateAdd("yyyy", MyDate,1)

freakazeud

Aug 28 2007, 12:32 PM

The syntax is the other way around:xpr1: DateAdd("yyyy", 1, MyDate)

TheZjooj

Aug 28 2007, 01:57 PM

Perfect!! Thank you both!!!

freakazeud

Aug 28 2007, 02:07 PM

You're welcome. 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.