Date Range dilemma

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

Hello all and thanks for reading,
Using: Access 2002 sp2

Trying to use the criteria to filter a date range from Date field on another
query.
This is for an Invoice Statement report where I need to find a past 30 days
late payment, 31 to 60, 61 to 90 and Over 90.

I can get the last 30 day with: Date()-30
I need something like: Between "Date()-31" and "Date() -60" etc...
I'm looking for a critera formula to do this function.

All suggestion would be greatly appreciated.
Thanks,
Chad
 
What is "Between #2/2/1999# And #12/1/1999#". Just
kidding. Don't put the quotes in, this should work in the
criteria field in a query.

Marty
 
I need something like: Between "Date()-31" and "Date() -60" etc...
I'm looking for a critera formula to do this function.
Click to expand...

Try:

BETWEEN DateAdd("d", -60, Date()) AND DateAdd("d", -31, Date())
 
Back
Top