Current Date + 3 years

[fiaola]

Hi,

I'm trying to create a Calcuated Field to add three years to today's date.
How do you do that in Access?

Thanks.

 

[Bob Barnes]

Try...
DateAdd("yyyy", 3, Date())

HTH - Bob

 

[Allen Browne]

Type an expression like this into the Field row in query design:
DateAdd("yyyy", 3, Date())