Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Time difference on Jira Export

Angie October 19, 2020

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
Carlos Garcia Navarro
Community Champion
March 5, 2022

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
Product Admin
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events