Limiting SQL select statements by AGE

2008-07-23 Thread Payne, George
ARS 7.0.01 P05 DB Oracle 10g I'm looking to make a Set Fields Filter Action to Count the number of records in an ARS Table where the value of the field is '1' and the record is more than 1 week old. This SQL works fine (returns a value for $1$ of =392): SELECT Count(C18099) FROM T1116

Re: Limiting SQL select statements by AGE

2008-07-23 Thread Axton
ad-u15 select sysdate from dual 2 / SYSDATE - 23-JUL-08 On Wed, Jul 23, 2008 at 3:09 PM, Payne, George [EMAIL PROTECTED] wrote: ** ARS 7.0.01 P05 DB Oracle 10g I'm looking to make a Set Fields Filter Action to Count the number of records in an ARS Table where the value of

RES: Limiting SQL select statements by AGE

2008-07-23 Thread Tadeu Augusto Dutra Pinto
Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Payne, George Enviada: qua 23/7/2008 16:09 Para: arslist@ARSLIST.ORG Assunto: Limiting SQL select statements by AGE ** ARS 7.0.01 P05 DB Oracle 10g I'm looking to make a Set

Re: Limiting SQL select statements by AGE

2008-07-23 Thread Grooms, Frederick W
is stored in the datbase as. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Payne, George Sent: Wednesday, July 23, 2008 2:10 PM To: arslist@ARSLIST.ORG Subject: Limiting SQL select statements by AGE ARS 7.0.01 P05 DB