Yep, you are right Kenn. I was translating the original query, your "Created > '2 weeks ago' " will be more efficient. - I think
Roy From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker Sent: 05 April 2011 17:39 To: rt-users@lists.bestpractical.com 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 <raed.el-ha...@daisygroupplc.com<mailto:raed.el-ha...@daisygroupplc.com>> wrote: Garry: Try: Created < 'now' AND Created > '2 week ago' AND Queue = 'FOO' Roy > -----Original Message----- > From: > rt-users-boun...@lists.bestpractical.com<mailto:rt-users-boun...@lists.bestpractical.com> > [mailto:rt-users-<mailto:rt-users-> > boun...@lists.bestpractical.com<mailto:boun...@lists.bestpractical.com>] 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
