Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Date value is mismatched between Query and CSV file

Questions
Tags
Users
Badges
yang lebo
(26●2●1) 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?

0 votes

6 answers
7,715 views
0 votes

6 answers

Permanent link
Steve Cotugno
(41●15●9) 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

 

1 vote

Permanent link
Jia Jia Li
(805●8●157●192) 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 votes

Permanent link
Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (30.1k●3●32●35) Mar 26 '12, 1:55 p.m.
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 votes

Permanent link
yang lebo
(26●2●1) 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 votes

Permanent link
Jia Jia Li
(805●8●157●192) 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 votes

Permanent link
yang lebo
(26●2●1) 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?

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Mar 25 '12, 11:22 p.m.

Question was seen: 7,715 times

Last updated: Oct 30 '12, 11:44 p.m.

Confirmation Cancel Confirm