Uploaded image for project: 'Jira Cloud'
  1. Jira 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
          hauschel1.jpg
          207 kB
        2. im1.PNG
          im1.PNG
          134 kB
        3. im2.PNG
          im2.PNG
          37 kB
        4. im3.PNG
          im3.PNG
          39 kB
        5. im4.PNG
          im4.PNG
          191 kB

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

              Created:
              Updated:
              Resolved: