It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,880

question asked: Mar 25 '12, 11:22 p.m.
question was seen: 4,630 times
last updated: Oct 30 '12, 11:44 p.m.

Related questions

Date value is mismatched between Query and CSV file

0
yang lebo (26●2●1) | asked Mar 25 '12, 11:22 p.m.
There is a gap between Query Result and exported CSV value.

For example, I input "2012-2-16" in a date field of a work item. Then I create a Query to search it, it shows "2012-2-16 AM 12:00". After that, I export it into a CSV file, but it shows "2012-2-15 PM 9:30".

It looks strange.
Why is it happened, and how can I fix it?

6 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Steve Cotugno (41●15●9) | answered Oct 30 '12, 11:40 p.m.
edited Oct 30 '12, 11:44 p.m.

Hello,

My client is having the same issue.  We are running V3.0.1.3.  See this example

   work item and CSV mismatch on date field
Please advise.

Thanks,

Steve

 

0
permanent link
Jia Jia Li (805●8●157●192) | answered Mar 26 '12, 12:29 p.m.
I do not think you can fix it. RTC store the date with long format... It can recognize the short format when import, but store long format....
0
permanent link
Geoffrey Clemm (30.1k●3●30●35) | answered Mar 26 '12, 1:55 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I don't think the poster was concerned about the date being converted to long form ... they were concerned that the date values were different.

Cheers,
Geoff

I do not think you can fix it. RTC store the date with long format... It can recognize the short format when import, but store long format....
0
permanent link
yang lebo (26●2●1) | answered Mar 26 '12, 10:03 p.m.
Yes. The data values in exported CSV were different from RTC. It was unacceptable. Are there any solutions?

I don't think the poster was concerned about the date being converted to long form ... they were concerned that the date values were different.

Cheers,
Geoff

I do not think you can fix it. RTC store the date with long format... It can recognize the short format when import, but store long format....
0
permanent link
Jia Jia Li (805●8●157●192) | answered Mar 29 '12, 12:20 p.m.
Ok, I get your point, but I have not encount this problem. Maybe your RTC server time zone is diff from your client?
0
permanent link
yang lebo (26●2●1) | answered Mar 29 '12, 10:04 p.m.
You give me a great viewpoint. I will check it. Thank you very much!

Ok, I get your point, but I have not encount this problem. Maybe your RTC server time zone is diff from your client?

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.