It's all about the answers!

Ask a question

Due Date is off by one day when filtering

Robert Myers (191116) | asked Sep 18 '14, 11:26 a.m.
Today is Sept 18, 2014 at 4 pm GMT. JTS is based in GMT -5. Due Date on WI is set to Sept. 19, 2014 12:00 PM (noon) (tomorrow).  RTC 5.0.1 Query filter is 'Today' and Work Item is displayed with Due Date = Sept. 19, 2014
If I set Query filter to tomorrow, WI is not found

One answer

permanent link
Eric Jodet (6.3k5111120) | answered Sep 24 '14, 8:53 a.m.
 Hello Robert,
it makes a long time I wanted to answer this one - but due to workload...
So, sorry for the delay.

Though I can not answer our question, I debugged the code and tried to query on due date "today" and "tomorrow".

Today: we create a time span from - date today - from 00:00:00.0 to 23:59:59.999
with a calendar created in Client's time zone (in your case, your time zone, in my case, Europe / Paris)

Tomorrow: same but with date set to tomorrow - but same time span

Now - when you - as  a WebClient - sets the due date to tomorrow 12PM - noon - we store this values based on your Client / context time zone and convert to zulu time.
Ex: for me, Europe / Paris, my context time zone is GMT + 2
So if I set due date to tomorrow 12PM, it will be stored to tomorrow 10 AM GMT - zulu

Now I don't know what is your time zone - but you may check what is the value of due date that you set using Firefox and Firebug.
1 - set a due date to to tomorrow 12PM - noon
2 - save
3 - open Firebug - net tab
4 - re-load the work item
5 - expand the answer for the getWorkItemDTO2 call

Not sure it helps right now, but we'll find an explanation.


Robert Myers commented Sep 26 '14, 11:44 a.m.

Not able to find JSON Tab.  How do I do that?
I found one reference to getWorkItemDTO2 in Script but that is probably not helpful.
var _50=new _2(_4c,"success","failure");

Eric Jodet commented Sep 29 '14, 1:43 a.m.


JSON tab is available from Firebug window.
Please ping me on ST if needed.


Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.