First of all, you need to determine what date range you're looking for. In other words what's the first date (120 days ago).
SELECT FILE WITH DATE GE "that_date". It will select everything in the file that falls after that date. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DG Sent: Wednesday, October 25, 2006 12:52 PM To: [email protected] Subject: [U2] Query calculating 120 days. When I do a query is like this: select table with term eq "some term" what I want to do is to select table within the last 120 or 60 days All I need is the term within the last 120 days or with in the last 6 months. The query will be run daily only to capture the lastest information. I having trouble getting the second to work. Any suggestions welcome. Thank you for advice. DG ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
