You don't say what problem you're having with the second one. Can you simply create a dictionary of the form
DATE_LESS_120 1> I 2> Date() - 120 3> D4 4> 120 days ago 5> 12R Then select with whatever date you're trying to match >= DATE_LESS_120 ? Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of DG > Sent: 25 October 2006 17:52 > 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/
