Hi Alex, Thanks for replying.
I found logs below, but no more details about it. [Tue Sep 2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make 'Sunday' 0 (/usr/share/request-tracker4/lib/RT/Date.pm:222) [Tue Sep 2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make 'last Sunday' 1409482532 (/usr/share/request-tracker4/lib/RT/Date.pm:222) [Tue Sep 2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make 'Sunday' 0 (/usr/share/request-tracker4/lib/RT/Date.pm:222) [Tue Sep 2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make 'last Sunday' 1409482532 (/usr/share/request-tracker4/lib/RT/Date.pm:222) And thanks for your reminding, I'm also aware of this, but our manager prefer that label, which is hard to config with the built-in attribute in RT. Br Vodar On Tue, Sep 2, 2014 at 6:35 PM, Alex Peters <[email protected]> wrote: > 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" <[email protected]> wrote: > >> 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 >> >
-- RT Training - Boston, September 9-10 http://bestpractical.com/training
