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] 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