Format date and time query

[wolfm]

I have been using a query to run a report for a date field to show records between 9 days ago and the current date. I have been using criteria: "Between Date() And Date()-9"
I now have added times to this field. However, now the report only shows records between 9 days ago and yesterday. How do I re-write my criteria to reflect records incorporating both date and time in this field, while showing records for today's date as well? A copy of my query is attached. Thank you!call list query.zip

[alansidman]

Try this:

Between Now() and Date()-9

[wolfm]

It worked! Thank you!