Odd date mapping when importing CSV export from Jira Cloud to Jira Product Discovery
Mart Postma
Rising Star 
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Hi all,
I'm using the Jira Cloud Excel plug-in to query some data from both Jira Cloud and Jira Product Discovery. When I export a CSV file from Jira Cloud, the date format in Jira Cloud (blue) is different than the date format in JPD (red).
Any suggestions/ideas on how to change the date formatting of JPD (red) such that it matches Jira Cloud's format?
1 answer
Rohan Swami
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Hi @Mart Postma the reason the date format of JPD is different is because JPD allows you to choose a 'fuzzy' date like a month or quarter, which is a string under the hood.
You could manipulate this once you're in excel with formulas like below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.