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

Inconsistency date Export using Date Custom Field with different Language Configured

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? 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:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: