criteria for last however many days

[lipin]

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.

 

[ColinEssex]

Between Now()-5 and Now()

Col