Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-500

Date Format changes when Issues are exported using "Open In MS EXCEL" option.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • None
    • None
    • Jira Cloud for Excel
    • None
    • Minor

      Issue Summary

      When we export issues in LIST VIEW using Jira for MS EXCEL, the DUE DATE and Start Date format gets changed. 

      Date format changes from 11/May/2021 to 2021-05-11

      Steps to Reproduce

      1. Try to export the issues using "open in MS Excel Option"
      2. When prompted for "Excel on Desktop" OR "Excel Online" , choose "Excel on Desktop"
      3. Open the downloaded file

      Expected Results

      All the date columns should be in the same format ie dd/mm/yyy 

      Actual Results

      The format for Due Date and Started Date changes to "YYYY-MM-DD"

      Workaround

      Currently, there is no known workaround for this behaviour. A workaround will be added here when available.

            [API-500] Date Format changes when Issues are exported using "Open In MS EXCEL" option.

            There are no comments yet on this issue.

              ac1d9a6a7e17 Mykyta Koptsov (Inactive)
              ab6ef5b5ed7f Harsaranjeet Kaur
              Affected customers:
              2 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: