[rt-users] Problem in searching date

[Chrilly Cheng]

Do I need to do any setting of the week on server?


On Tue, Sep 2, 2014 at 3:59 PM, Chrilly Cheng <chrilde at gmail.com> 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140902/16e1afa0/attachment.htm>