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?
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.
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!
👋 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...
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