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

XMLWordPrintable

    • Type: Bug
    • Resolution: Tracked Elsewhere
    • Priority: Low
    • None
    • Affects Version/s: None
    • Component/s: Navigation - Export
    • None

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? 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. D.png
          D.png
          96 kB
        2. C.png
          C.png
          56 kB
        3. B.png
          B.png
          51 kB
        4. A.png
          A.png
          26 kB

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

              Created:
              Updated:
              Resolved: