Query in RTC: Excel somehow cannot recognize the Date filed as TYPE Date
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
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
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.