Do I need to do any setting of the week on server?
On Tue, Sep 2, 2014 at 3:59 PM, Chrilly Cheng <[email protected]> wrote: > Hi Guys, > > I was trying to create a qeury which returns all open tickets whose > "Proposed Start Date" are in this week, from specific queue. I tried with > some build-in variables in searching as showing below: > > Queue = 'ChangeRequest' AND ( Status != 'rejected' AND Status != > 'resolved' ) AND 'CF.{Proposed Start Time}' > 'last Sunday' AND > 'CF.{Proposed Start Time}' < 'Sunday' > > but this query returns nothing. BTW, "Proposed Start Time" is a datetime > custom field applied to this queue. > > Can you please help to check on this, see whether it doesn't work? Many > thanks. > > > Br > Vodar > > >
-- RT Training - Boston, September 9-10 http://bestpractical.com/training
