Dates fields show different date in field, History and exports than what is uploaded
Hi,
I keep getting a question from RTC users about the challenges associated with Dates in RTC.
The challenge is as follows. Say i want to upload 1st October 2014 as date in RTC. my server is located at US. I am in india.
Now when I upload this date
- the work item on web client shows "1st oct 2014"
- History of work item shows 3oth Sep 2014
- Export also shows 30 sep 2014
I understand that because of timezone difference between india and server at US it is happening but when history and export is showing 30th sep why work item at front end is showing "1st Oct"? this should also show the value which is gone to database i.e. 30 sep.
Do we have any explanation for this? please share.
2 answers
Hi Pradnya --> When you say you upload this date, do you mean the work item creation date displayed in the GUI? --> What version of RTC is being used here? --> Is this the behavior seen for all work item types? And in both web client and Eclipse client? --> I just did a quick check on this in RTC 4.0.4: ***** a. There was this work item I had created in India time and worked with one of the developers located in Canada. b. There was an update on this WI yesterday i.e. 06th Nov 2013, 08:16:37 PM (India time) for me. This is the time reflected at my end on the WI. c. Even the History on the WI showed the last update/change time as 06th Nov 2013, 08:16:37. e. Out of curiosity, I asked the developer to open this same WI and see the last update. For him it showed as Nov 6, 2013, 09:46:37 AM. This is the time showed in the history as well as the Work Item for the developer located in Canada. ***** So what the history and the work item displays depends on which location you are accessing the WI and the system clock. --> While I do not have a suitable explanation, the work item front end will show the time with respect to the local time zones/system clock. I believe it is the NTP server being used which calculates and displays time based on system clock, irrespective of the location of the database or the RTC server.
Hi,
I have the same problem : my RTC server is located in France and when I create (from France) a work item for example at 12:00, it shows 12:00 in creation date and in the history.
But if a colleague in UK looks at this work item, creation date is 11:00 (that is normal) but in the history it is still 12:00.
I tried to see if there is a problem with the NTP server, but it does not seem to.
Does anyone has an explanation or a solution for that ?
Thank you for your help,
Regards
Marie
I have the same problem : my RTC server is located in France and when I create (from France) a work item for example at 12:00, it shows 12:00 in creation date and in the history.
But if a colleague in UK looks at this work item, creation date is 11:00 (that is normal) but in the history it is still 12:00.
I tried to see if there is a problem with the NTP server, but it does not seem to.
Does anyone has an explanation or a solution for that ?
Thank you for your help,
Regards
Marie