Dates Older Than

  • Thread starter Thread starter DS
  • Start date Start date
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
 
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.
 
Back
Top