Query for Date Plus 10 Years

[Barclay Berger]

How do I build a query that will take a date plus 10 years? I've tried
Exp: [recdate] + 3650?

Thanks

Barclay

 

[Cheryl Fischer]

There is a function named DateAdd() that will do that for you. If you want
to use it as a calculated field in a query, put the following in the top row
of a column in Query Design:

NewDate: DateAdd("yyyy", 10, [MyDate])

hth,