Extract data within past 2 years of todays date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top