Dates with different format when exporting to excel

JPB June 11, 2014

Searching for issues, I filter by project, then by issue type, for example 'bug', After that I click the 'Export' button, as shown in the picture.

Then I click the 'Excel (All fields)' link to generate the Excel file, but when I open the file, and look for the dates in the 'Created' field, I see that some dates have a date format, and others a general format, as shown in the picture.

The thing is that the users make a filter in excel and get this:

And they want all the dates as pointed in 'We want this' in the image above.

The 'Created' field is manipulated by the system, not by users. I checked the database and found that the values are ok (all dates have the same format), so, I think this is a problem when exporting the file from JIRA.

Any ideas? Thanks

1 answer

1 accepted

1 vote
Answer accepted
Vijay Khacharia
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 15, 2014
JPB June 16, 2014

Hi Vijay, that helped, that was the problem, thank you!

Suggest an answer

Log in or Sign up to answer