adding years to date range

  • Thread starter Thread starter tonyrulesyall
  • Start date Start date
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?
 
Use DateAdd() to add 3 years:
Between [date_selected] And DateAdd("yyyy", 3, [date_selected])
 
Back
Top