Extract data within past 2 years of todays date

[Guest]

I need to extract data where the date field (it_date) is within 2 years of
today's date.

The it_date field only shows dates as the last day of the relevant month,
i.e. 31/01, 28/02, 31/03, 30/04, etc. If today is 09/10/2007, I would want
to extract any data where it_date is between 31/10/2005 and 31/10/2007.

How can I write this as an Access query (in the query design view)?

Thanks in advance.

 

[Allen Browne]

In the Criteria row below it_date in query design, enter: