Query criteria to return < 2 years remaining

[claine]

Hello

I am trying to create a parameter query to return dates that have 2 years remaining.

For example I have dates for when mortgages expire, and I want to recognise the dates that have two years remaining using a parameter query but I can't figure out if I use DateAdd or DateDiff.

Charlotte

 

[Brianwarnock]

Iif(expirydate<dateadd("yyyy",2,Date())

Brian

 

[claine]

Thank you Brianwarnock

I think I over complicate things sometimes as I tried > Date() to return the dates, which were still in date to give me the years remaining.

Thank you for your help.

Charlotte