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,257,426
Community Members
 
Community Events
164
Community Groups

Time difference on Jira Export

Greetings i want to understand why we have 2 hours behind difference from our issues

 

When searching an Issue on Jira the Date Created displays as: Created June 19, 2020, 9:42 AM

But as soon as I open it in Microsoft Excel its show 2hours behind difference 

On Open in Microsoft Excel: 2020/06/19 07:42 am 

Im from South Africa

Please could you advise on why the JIRA Export to Excel Function is having this issue.

As a side note we would use CSV, but this is restricted to 1000 records in search and export, so not helpful when exporting larger files.

1 answer

0 votes

Hi @Angie ,

I know this is an "old" ticket but just in case you're still looking into this: This seems to be a bug, where the issues in the export are in UTC time rather than local (if you're in South Africa, one of he timezones there is UTC+2). There is also this post that talks about the issue: https://community.atlassian.com/t5/Jira-Service-Management/Time-is-wrong-when-I-export-to-excel/qaq-p/1811186 

And the corresponding Atlassian ticket here: https://jira.atlassian.com/browse/API-272, describes the issue and offers a couple of workarounds.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Safe customer notifications in Jira Service Management for compliance and privacy needs

Announcing safe customer notifications in Jira Service Management as a building block for compliance and privacy needs At Atlassian, we understand the increasing need to be assured that your data i...

375 views 1 14
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