Exporting Issues in CSV and date formatting

Using the "Issues in CSV" feature, the CSV files have dates that don't format in excel. Columns for Created, Updated and Resolved all have the day of the week and timezone information as well as nomal date - Tuesday, May 20, 2014 3:59:15 PM -06:00

If the day of the week and the timezone information was removed it becomes formattable by Excel - May 20, 2014 3:59:15 PM

Is there a way for me to change how the dates show up on export?
1 comment
Comment actions Permalink
I recently discovered this myself, though it looks like this issue has been around for many years. I just added a comment to http://youtrack.jetbrains.com/issue/JT-11648#comment=27-796319 with a Python script we're using as a workaround to make these dates parseable for now.

Please sign in to leave a comment.