IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
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

    • 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. 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

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            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

              • 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. 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:
                        10 Start watching this issue

                          Created:
                          Updated:
                          Resolved:

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

                              Created:
                              Updated:
                              Resolved: