[JRASERVER-11360] Date format is inconsistent during Export to Excel - Create and track feature requests for Atlassian products.

Type: Bug
Resolution: Not a bug
Priority: Low (View bug fix roadmap)
Fix Version/s: None
Affects Version/s: 3.6.5, 6.3
Component/s: Navigation - Export
Labels:
- affects-cloud
- affects-server

Introduced in Version:
3.06
Bug Fix Policy:
View Atlassian Server bug fix policy

When a user exports to excel by clicking on 'All Fields' the date formats in Excel differ between issues (rows).

Some result in the general form (05/Oct/06 10:56 AM) while others use the 24hour format like so (22/09/2006 14:11:00).

For more information see JSP-7554.

Workaround

https://confluence.atlassian.com/display/JIRAKB/Date+format+changes+after+exporting+to+Excel

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

Date Format Example.jpg
54 kB
18/Aug/2009 7:48 AM
date-format-excel-export-issues.png
42 kB
07/Jul/2015 1:31 PM

is superseded by

JRASERVER-32352 Excel Export Is Broken With Office 2010 or 2013 / LibreOffice / Numbers

Closed

was cloned as

JRASERVER-60088 Date format is inconsistent during Export to Excel

Closed

mentioned in: Date format changes after exporting to Excel from Jira Data Center; Page No Confluence page found with the given URL.

No work has yet been logged on this issue.

Assignee:: Unassigned

Reporter:: Michelle de Guzman

Affected customers:: 0 This affects my team

Watchers:: 25 Start watching this issue

Created:: 24/Oct/2006 4:35 AM

Updated:: 27/Mar/2019 11:51 PM

Resolved:: 31/Oct/2006 12:26 AM