Yep, you are right Kenn. I was translating the original query, your "Created > '2 weeks ago' " will be more efficient. - I think
Roy From: [email protected] [mailto:[email protected]] On Behalf Of Kenneth Crocker Sent: 05 April 2011 17:39 To: [email protected] Subject: Re: [rt-users] search by today Raed, Isn't the "now" kind of intuitive? Wouldn't "Created > '2 weeks ago' work just as well since the query is already running 'Today' or realtime? Unless you can created dates in the future, but I would think that unlikely. Just a theological thought, ;-). Kenn LBNL On Tue, Apr 5, 2011 at 8:28 AM, Raed El-Hames <[email protected]<mailto:[email protected]>> wrote: Garry: Try: Created < 'now' AND Created > '2 week ago' AND Queue = 'FOO' Roy > -----Original Message----- > From: > [email protected]<mailto:[email protected]> > [mailto:rt-users-<mailto:rt-users-> > [email protected]<mailto:[email protected]>] On > Behalf Of Garry Booth > Sent: 05 April 2011 16:05 > To: RT Users > Subject: [rt-users] search by today > > Hi All > > does anybody know if there is a way to dynamically search through > tickets with creation dates from today to two weeks ago, without > changing the dates every time? > > e.g. Created < 'NOW' AND Created > 'NOW -13' AND Queue = 'FOO' > > regards > > Garry
