Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-59791

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Tracked Elsewhere
    • Low
    • None
    • None
    • Navigation - Export
    • None

    Description

      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

      Attachments

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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: