Filter date on query

[Riaang]

Hi all,

I've created an Access Query but in one of the date fields I need to filter the data so that it only shows me prior to the last 30 days. The last 30 days prior to todays date (which updates every day) must not be seen.

I have tried "now()-30" and "Date()-30"

Thanks

 

[Russell Hauf]

Under your Date field in the query's design view, put:

< Date()-30

HTH,

Russell

 

[Riaang]

Thanks Russel