All records within the last 30 days

[Guest]

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

 

[Guest]

SELECT *
FROM YourTable
WHERE YourDate >= DATE()-30;

Ken Sheridan
Stafford

 

[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())