All records within the last 30 days

I

Iram

Hello.
I am using Access 2000 and I was wondering how to write a query on a date
field to find all records within the last 30 days.

I tried Date()-30 and it didn't work.
Any suggestions?

Your help is greatly appreciated.

Iram/mcp
 
J

John Spencer

Field: YourDateField
Criteria: Between DateAdd("d",-30,Date()) and Date()

Even simpler if you don't have dates in the future

Criteria: >= DateAdd("d',-30,Date())
 
Top