Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-30777

Inconsistency date Export using Date Custom Field with different Language Configured

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

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

      When the language configured in JIRA is different with the Machine OS, exporting filter to excel will cause the date mismatch in term of format and display.

      JIRA should parse the Date format in number(perhaps something) rather than the date as the Excel will use the Regional Language in the Machine.

      Example:-
      JIRA's Language = English

      Machine OS's Language = Dutch (Belgium)

      When exporting Date Custom Field in JIRA which is supposed to be dd/MMM/yy

      Result:-

      Expected Result:-
      The Date in Excel should all be consistence but due to some conversion made by Excel based on Regional Language of OS's Language.

      Workaround:-
      Set the same language in JIRA and the OS

      Suggestion:-
      Parse the date as number instead of MMM?

        1. hauschel1.jpg
          207 kB
          Fred Hauschel
        2. im1.PNG
          134 kB
          KhongMingA
        3. im2.PNG
          37 kB
          KhongMingA
        4. im3.PNG
          39 kB
          KhongMingA
        5. im4.PNG
          191 kB
          KhongMingA

              Unassigned Unassigned
              kkok KhongMingA
              Votes:
              5 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated:
                Resolved: