Query for Date Plus 10 Years

B

Barclay Berger

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

Thanks

Barclay
 
C

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,
 
Top