Dates Older Than

D

DS

I have a Query that I want to run. I want it to show Dates older than
20 Days from Today. The field that has the dates in it is SalesDate.

I tried putting this is the criretia section of the Query but this did
not work.

Now()>20

Any Suggestions?
Thanks
DS
 
R

Rick Brandt

DS said:
I have a Query that I want to run. I want it to show Dates older than
20 Days from Today. The field that has the dates in it is SalesDate.

I tried putting this is the criretia section of the Query but this did
not work.

Now()>20
Click to expand...

< Now() - 20

Actually, it would be better to use...

<Date()-20

....unless you really want to factor the time of day into it.
 
Top