How do I set up a query for information prior to the prior year?

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

Guest

I need to have a query pull just the information prior to the previous year.
This query will be used to pull information for a report that will be run
every year.
 
I think it would be...

Between DateSerial(Year(date())-2,1,1) and DateSerial(Year(date())-2,12,31)
 
I take it that you mean anything on or before 31/Dec/2003 if you run the
Query today?

In that case, use:

.... WHERE [DateField] < DateSerial(Year(Date()) - 1, 1, 1)
 
Back
Top