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. im1.PNG
          im1.PNG
          134 kB
        2. im2.PNG
          im2.PNG
          37 kB
        3. im3.PNG
          im3.PNG
          39 kB
        4. im4.PNG
          im4.PNG
          191 kB
        5. hauschel1.jpg
          hauschel1.jpg
          207 kB

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

                Created:
                Updated:
                Resolved: