Excel Download in Issue navaigator does not give unform data format

SuhailM July 22, 2012

Hi,

when i download excel from the issue navigator screen i see all sorts of date format.Is there any way where i can get uniform date formats in excel.

Regards,

Mir

1 answer

1 accepted

0 votes
Answer accepted
Jobin Kuruvilla [Adaptavist]
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.
July 22, 2012

All the JIRA standard dates should be in the same format. I am guessing you are seeing different formats for third party custom fields and if so, there is nothing you can do unless there is an option to modify that format provided by the plugin itself.

SuhailM July 23, 2012

The field name is issue" created "which is not a custom field .. and this has different date formats in excel.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 23, 2012

To clarify here - when you do a download to excel, you include the column "created" and you get rows with different date formats?

SuhailM July 23, 2012

Yes. Exactly.

Jobin Kuruvilla [Adaptavist]
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.
July 23, 2012

Can you export that Excel to CSV and see how the dates are coming when you open it in a Text editor?

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 23, 2012

Or, even don't export, just open the downloaded file in a text editor...

Suggest an answer

Log in or Sign up to answer