T tdenmark New member Local time Today, 13:41 Joined Aug 24, 2005 Messages 1 Aug 30, 2005 #1 I have this query that I want to return only records where the date(mm/dd/yyyy) is less than 30 days old. Anybody got a suggestion?
I have this query that I want to return only records where the date(mm/dd/yyyy) is less than 30 days old. Anybody got a suggestion?
pbaldy Wino Moderator Staff member Local time Today, 11:41 Joined Aug 30, 2003 Messages 36,256 Aug 30, 2005 #2 WHERE DateField > (Date() - 30)
N nshah1013 Registered User. Local time Today, 11:41 Joined Aug 24, 2005 Messages 13 Aug 30, 2005 #3 in Criteria section where the date field is put Now()-[Date]<30 [Date] (Date is name of column)
R raskew AWF VIP Local time Today, 13:41 Joined Jun 2, 2001 Messages 2,733 Aug 31, 2005 #4 nshah1013, In addition, if your field is named [date], rename it. MyDate, YourDate, whatever...but not [Date]. 'Date' is a reserved word, the name of a function, and it will ultimately come back to bite you. Bob
nshah1013, In addition, if your field is named [date], rename it. MyDate, YourDate, whatever...but not [Date]. 'Date' is a reserved word, the name of a function, and it will ultimately come back to bite you. Bob
N nshah1013 Registered User. Local time Today, 11:41 Joined Aug 24, 2005 Messages 13 Aug 31, 2005 #5 Thank you guys for your input. i will keep in mind.
