Date query wanting the last 180 days

techexpressinc

Registered User.
Local time
Today, 08:26
Joined
Nov 26, 2008
Messages
185
I want records less than 180 days old. I coded it up as
<Date()-180

But it does not work.
Any ideas for improvement?

A picture of the query is attached to look at.
Thanks
Russ
rneuman at scaninc.org
 

Attachments

  • Accesslessthan180.JPG
    Accesslessthan180.JPG
    45.6 KB · Views: 467
Don't you want > instead of <?
 
Never mind - Duh - the < should be >
 

Users who are viewing this thread

Back
Top Bottom