Tyring to query for the last 5 days:

In 'date' field of query I have tried with the criteria as:

[Date]-5
=Date-5
Date-5
Now()-5
=Now()-5

Can't get any results!!
Please help.

Between Now()-5 and Now()

Col
:cool:

>= Date() - 5