techexpressinc Registered User. Local time Today, 08:26 Joined Nov 26, 2008 Messages 185 Jun 4, 2009 #1 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 45.6 KB · Views: 467
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
pbaldy Wino Moderator Staff member Local time Today, 05:26 Joined Aug 30, 2003 Messages 36,270 Jun 4, 2009 #2 Don't you want > instead of <?
techexpressinc Registered User. Local time Today, 08:26 Joined Nov 26, 2008 Messages 185 Jun 4, 2009 #3 Never mind - Duh - the < should be >