JIRA 7 has landed! Are you an existing JIRA user with questions about upgrading? Visit the Migration Hub for information about upgrading to new JIRA applications

Skip to end of metadata
Go to start of metadata


The date format shown in Excel does not reflect the date format which is shown in the JIRA application user interface.


  1. Excel determines the date format based on local settings. If your local machine has a different date format than JIRA applications, 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 configured correctly ( JRA-11360 - Date format is inconsistent during Export to Excel Resolved ). 


Ensure the end user machine Regional and Language setting is not other than English.


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

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" 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 and Disable relative dates in JIRA applications 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

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









Oct 1, 2010

MMM d, yyyy

%b %e, %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

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


Help us improve!

Is this article helpful?
Is it well written?
Is the content complete?


  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.


  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