Need records between current date and specified past date

  • Thread starter Thread starter Dave69
  • Start date Start date
D

Dave69

My brain has stopped working.

I just need a simple query or function that retrieves records from now until
10 years ago.

Thanks in advance!
 
My brain has stopped working.

I just need a simple query or function that retrieves records from now until
10 years ago.

Thanks in advance!
Click to expand...

Exactly to the day 10 years ago?
As criteria on the date field ...

Between Date() and DateAdd("yyyy",-10,Date())
 
Exactly ten years to the day? Use criteria like the following

Between DateAdd("yyyy",-10, Date()) and Date()

Ten years ago starting on Jan 1
Between DateSerial(Year(Date())-10,1,1,) and Date()

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
My brain has stopped working.

I just need a simple query or function that retrieves records from now until
10 years ago.

Thanks in advance!
Click to expand...

A criterion

BETWEEN DateAdd("yyyy", -10, Date()) AND Date()

should work.

John W. Vinson [MVP]
 
Back
Top