Welcome to the Jazz Community Forum
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
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