[rt-users] Problem in searching date

[Alex Peters]

What does the debug log say when you run the search?

There are some config options relevant to relative dates, but it's worth
verifying first that the two dates are being parsed at all.

P.S.  I believe that the built-in Starts ticket attribute is intended to
function as a proposed start time.
On 02/09/2014 8:25 pm, "Chrilly Cheng" <chrilde at gmail.com> wrote:

> 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
>>
>>
>>
>
> --
> RT Training - Boston, September 9-10
> http://bestpractical.com/training
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140902/40c19baa/attachment.htm>