It's all about the answers!

Ask a question

Query in RTC: Excel somehow cannot recognize the Date filed as TYPE Date


Ratheesh Madathil (1371325) | asked Jun 28 '16, 11:53 a.m.

We have a problem in RTC (CLM 6.0.1) currently.

Problem:

 -       You make a query with a date field in it (e.g creation date, resolution date etc..)

 -       Try to export the query results to excel

 -       Excel somehow cannot recognize the Date filed as TYPE Date

This now makes the issue for our users that they cannot for e.g. make analysis in Excel using the date field. We tried a little with that by changing the excel cell property, formatting etc…but without success. Excel detects the dates as plain text.

Can one of you try and find a solution for this?

Accepted answer


permanent link
Donald Nong (14.4k314) | answered Jun 29 '16, 1:27 a.m.
It's a known issue.

If you're using the Eclipse client, you can try this solution.
https://jazz.net/forum/questions/38576/date-format-in-csv-export

If you're using the web client exclusively, you probably have to use an Excel macro to convert the date values.
https://jazz.net/forum/questions/214935/csv-import-gives-wrong-dates-in-region-frenchfrance-as-the-date-format-is-not-supported-by-rtc

Note that a new server property has been introduced in the latest version to allow you to specify the ISO 8601 date format in the CSV export.
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/354917
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/390362

Ratheesh Madathil selected this answer as the correct answer

Your answer


Register or to post your answer.