Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,777
Community Members
 
Community Events
165
Community Groups

Incorrect Date shown for CSV export on Date-Picker type custom Fields after Jira 8.19 Upgrade

We have a self-hosted version of Jira Software and we recently upgraded the version to Jira 8.19.

When we export a CSV file from our instance fields such as Created, Updated, Resolved shows the correct date as displayed in Jira. But we have other custom fields (Only Date Picker type - Not Date-time), these fields show up in the exported CSV file incorrectly.

For example  - Our Custom field shows the date as 13/Aug/2021 in the Jira application but the exported CSV file shows the date as 12/Aug/2021 06:30:00PM. 

All the records show the previous date with the "06:30:00PM" time.

This is applicable to all date type custom fields and the due date field as well (so basically all Date-Picker type fields)

Can anyone assist me in solving this?

 

 

 

3 answers

Not sure what exactly to recommend about this situation, but might it have something to do with time zones?

Is it possible that your server uses a specific time, your browser uses a +6:30 time zone and there is some setting in the Jira profile that doesn't reflect the different time zones (i.e. UTC vs India time)? Try doing some investigations around that.

Hello @Tharindu Dinuth Maddumahewage

Di you have any response for this error? Is there any way to resolve it?

Best regards

Hello @Barcelo [Administrator] and @Tharindu Dinuth Maddumahewage,

The mentioned problem looks similar to known defect JRASERVER-72382. According to the description, this defect was introduced as regression stating from Jira 8.16 and affects CSV exports (HTML and XML are not impacted). 

It appears to be fixed already (starting from Jira 8.20.4), so upgrading to this or a higher version should help you to prevent this problem.

Hope this helps!

Alexander

Like 3digits - Desarrollo likes this

Just noting that you are not alone, some of our customers are experiencing the same issue. I suggest you raise a support issue with Atlassian via support.atlassian.com

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,488 views 37 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you