S spleewars Registered User. Local time Today, 00:53 Joined Jan 28, 2011 Messages 28 Apr 18, 2012 #1 is it possible to set a query with the following code on a field: <date()-180 and <date()-365 what i want is to to show records from 6 months to 12 months only. what am i doing wrong?
is it possible to set a query with the following code on a field: <date()-180 and <date()-365 what i want is to to show records from 6 months to 12 months only. what am i doing wrong?
B Beetle Duly Registered Boozer Local time Today, 01:53 Joined Apr 30, 2011 Messages 1,807 Apr 18, 2012 #2 You're using less than on both sides of the argument. Should be; <=Date()-180 And >=Date()-365
