JIRA Documentation

JIRA 6.3 EAP
JIRA 6.0 Documentation
JIRA 5.2 Documentation
JIRA 5.1 Documentation
More...
 

 

Search the Knowledge Base and Documentation Spaces

You're visiting the JIRA Knowledge Base. Visit the JIRA Knowledge Base Home for an overview.

Skip to end of metadata
Go to start of metadata

Symptoms

The date format shown in Excel does not reflect the date format which is shown in the JIRA User Interface.

Cause

  1. Excel determines the date format based on local settings. If your local machine has a different date format than JIRA, then the settings will not match each other.
  2. There is also a known bug regarding the date format change even though the setting in javascript is configure correctly, please see  JRA-11360 - Date format is inconsistent during Export to Excel Resolved . To verify this, please ensure the end user machine Regional and Language setting is not other than English.

Resolution

Change the date format on your local machine to the one used in JIRA.

The Look and Feel page allows you to customize the way times and dates are presented to users throughout the JIRA user interface.

When specifying dates and times, they should be based on the Java SimpleDateFormat.

When you are not in edit mode on the 'Look and Feel' page, the examples in the rightmost column of the Date/Time Formats section show you how the various formats will appear in JIRA.

Relative time is used in date/time formats

Issue date/time fields show a relative instead of absolute date/time format (for example: Yesterday 12:00 PM instead of 20 May 2013 12:00 PM). You can still see the absolute date/time by hovering over the field.

(info) The date/time format reverts to absolute after a week.

If you want to switch off this format, set the jira.lf.date.relativize application property to 'false'. See Advanced JIRA Configuration for more information.

Configuring date picker formats

JIRA system administrators can configure the format of date pickers used throughout the JIRA user interface via options on the Advanced Settings page.


(info) Be aware that these options are different from the Date/Time Formats configuration options on the Look and Feel page, which only customize JIRA's presentation of times and dates to users.

(warning) The date or date/time formats for date pickers are defined by a pair of properties (one for Java and the other for JavaScript). The two properties in this Java/JavaScript pair must match in order for the date (or date/time) picker they define to function correctly.

Here are some example US-based date configurations:

Preferred Date

Value of the jira.date.picker.java.format property

Value of the jira.date.picker.javascript.format property

Comments
2010-10-01yyyy-MM-dd%Y-%m-%dISO 8601 format

Oct/1/10

MMM/d/yy

%b/%e/%y

 

10/01/10

MM/dd/yy

%m/%d/%y

 

Oct 1, 2010

MMM d, yyyy

%b %e, %Y

 

10/01/2010

MM/dd/yyyy

%m/%d/%Y

 

Here are some examples of date/time configurations:

Preferred Date/Time

Value of the jira.date.time.picker.java.format property

Value of the jira.date.time.picker.javascript.format property

Comments
2010-10-15 08:50yyyy-MM-dd HH:mm%Y-%m-%d %H:%MISO 8601 format

15/Oct/10 8:50 AM

dd/MMM/yy h:mm a

%d/%b/%y %l:%M %p

 

10/15/10 08:50 AM

MM/dd/yy hh:mm a

%m/%d/%y %I:%M %p

 

Related Content

 Expand to see related content

Related Content with Label 'export-excel'

Help us improve!
Is this article helpful?
Is the content complete?
Is it well written?

4 Comments

  1. it would be better if you specify exactly how to "Change the date format on your local machine to the one used in JIRA" as described here

    1. Thanks for the comment. I've added the content from our documentation here into the article.

  2. Hi Jeremy,

    What if your jira-application.properties file specifies a format that doesn't contain '/' or '-' as date delimiters, such as:

    We end up with an Excel file containing all sorts of inconsistently-formatted dates, e.g.,

    • Dec 23, 2010 13:10 pm (Created Date)
    • 31-Jan-11 (Due Date)
    • 12/17/2010 9:08 (Resolved Date)

    ...and the Start > Settings > Control Panel > Regional and Language Options > Dates settings doesn't allow one to specify no delimiter.

    Thanks!

  3. How do I get the date to be exported with hh:mm when I use subscription.  If I just use the filter and export, the date field is exported with hh:mm, however I could not get that with I use subscription.  The date I am after is Create