Dates Older Than

[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

 

[Ken Snell [MVP]]

Dates older than 20 days from Today?

< (Date() + 20)

 

[Rick Brandt]

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

< Now() - 20

Actually, it would be better to use...

<Date()-20

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

 

[DS]

Dates older than 20 days from Today?

< (Date() + 20)

Thanks,
I did < (Date() -20) and that worked fine!
DS