Subtract 2 years from enrollment date

[Graham T]

Please could anyone advise on the date function required to subtract 2 years from a date field contained in my query.

The field in question is [dtmEnrolled] and formatted as dd/mm/yy. From this I wish to subtract 2 years to find out if the course length has expired.

Sorry if this has been asked a thousand times, I have searched but to no avail.

Thanks

 

[Rich]

=DateAdd("yyyy",-2,[dtmEnrolled])

 

[Graham T]

Thanks for the reply Rich.

It pushed me in the right direction, however I needed to amend the criteria to get the correct information I was looking for (didn't explain myself very well!).

I used the following to find enrollment dates greater than or equal to 2 years prior to today's date:

<=DateAdd("yyyy",-2,Date())