Date Range dilemma

[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

 

[Marty]

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

 

[John Vinson]

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

Try:

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

 

[Chad]

Perfect... Thanks John

Try:

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