Date/DateTime Picker log format different in UI and Date exported to excel shows different date

XMLWordPrintable

      NOTE: This bug report is for JIRA Cloud. Using JIRA Server? See the corresponding bug report.

      Summary

      I did change the format for both Date and Date Time picker but the look and feel is not showing the correct format. Lets say I used the format for DateTime and Date picker as

      • jira.date.picker.java.format=yyyy-MM-dd
      • jira.date.picker.javascript.format=%Y-%m-%d
      • jira.date.time.picker.java.format=yyyy-MM-dd HH:mm
      • jira.date.time.picker.javascript.format=%Y-%m-%d %H:%M

      Set the date as
      Date=02/09/1900
      DateTIme=1900-02-02 18:02

      • When viewing it via browsing it image A ( Format is showing differently in UI )
      • When you try to edit it image B & C ( These looks fine )
      • When you export it via excel image D ( DatePicker format/data is wrong ).
        Verified in backend and dates are correct.

      Steps to Reproduce

      1. Login to JIRA as SYS Admin
      2. [Change Date and Date time format||https://confluence.atlassian.com/jira/changing-the-due-date-input-format-192536.html] using above format.

      Expected Results

      Format in UI and extracting data for DatePicker should be same data and format.

      Actual Results

      Check Image A and Image D column DatePicker field.

      Workaround

      No workaround

        1. A.png
          A.png
          26 kB
        2. B.png
          B.png
          51 kB
        3. D.png
          D.png
          96 kB
        4. C.png
          C.png
          56 kB

            Assignee:
            Unassigned
            Reporter:
            Jason Liwag (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: