Make a dictionary item for the age of the transaction. 0001 I 0002 DATE()[EMAIL PROTECTED]<6> 0003 0004 AGE 0005 10R 0006 S
Substitute the attribute number in @RECORD for the transaction date in your data. Then you would just: select table with age le "120" and with term eq "some term" HTH, Gordon Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 10/25/2006 12:51:53 PM: > 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 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
