[rt-users] Problem in querying date of one week.

[Chrilly Cheng]

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 anyone please help to check on this, see whether it doesn't work? Many
thanks.


Br
Vodar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140902/82fd55c9/attachment.htm>