Build Query for records from the last 30 days

[jsquyre]

I have a table that I need to pull only the records from the past 30 days. I have a date field that I want to use but I'm having problems coming up with the correct expression for the criteria to bring up only those records that are 30 days old or less. Can someone help?

 

[John Big Booty]

Welcome to the forum.

Try using ;

>= Date() - 30

as your criteria

 

[jsquyre]

Thanks a bunch! That did the trick.