Criteria to return results from last 30 days

[Guitarzan]

I have a date field I'm querying and want to return results from the last 30 days.



I originally tried to use this criteria: >=DateAdd("d",-30,Date())

but my field contains dates in the future too but I only want it from 30 days ago until today. What is the criteria I can use to accomplish this?

[JoeM]

Try:

Between DateAdd("d",-30,Date()) And Date()

[Guitarzan]

Try:

Between DateAdd("d",-30,Date()) And Date()

Worked perfectly. Thank you!

[JoeM]

You are welcome!