adding years to date range

T

tonyrulesyall

I have an access query that I want to put a range of dates in.

I would like it to have this format:

between [date_selected] and [date_selected + 3 years]

How would I go about doing this?
 
A

Allen Browne

Use DateAdd() to add 3 years:
Between [date_selected] And DateAdd("yyyy", 3, [date_selected])
 
Top