Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Time zone descrepancy between WBS Gantt Chart and exported excel

Y.H I'm New Here Jul 07, 2021

I added some custom fields as date picker in JIRA and displayed them as WBS Gantt Chart columns too.

They are available in WBS Gantt Chart screen correctly, however, when I export WBS Gantt Chart to excel, it seems the date fields are converted to another time zone.

 

Current situation;
  Windows setting: UTC+9
  JIRA personal setting: UTC+1
  Date field input in JIRA : 2021/7/5
     -> displayed as 2021/7/5 in WBS Gantt Chart
          -> exported as 2021/7/4 in excel

I tried;
  Windows setting: UTC                                                  <- I changed here
  JIRA personal setting: UTC+1
  Date field input in JIRA : 2021/7/5
     -> displayed as 2021/7/5 in WBS Gantt Chart
          -> exported as 2021/7/5 in excel             <- It worked

 

From the result of what I tried above, it seems that the date is converted from Windows time zone to UTC when WBS Gantt Chart is exported to excel.

Is there any setting which allows us to export the date field in the correct time zone the same as displayed in WBS Gantt Chart with below setting as well?
  Windows setting: UTC+9
  JIRA personal setting: UTC+1

1 answer

Hello @Y.H ,

This is Hal from Ricksoft. We tried to reproduce the behaviour, but could not do that.

Could you please take a video while the issue is being reproduced and send it to our support desk?

Thank you for your cooperation!

Sincerely.
Hal
Ricksoft

Y.H I'm New Here Jul 15, 2021

Hello @Hal ,

Thank you very much for your support.

I took a video to explain what happens to us and sent it to the support desk from the link you mentioned.

I hope it would be helpful for your team to replicate the issue.

Best regards,
Y_H

Like Hal likes this

Hello @Y.H ,

Thank you so much! We'll do our best to resolve the issue.

All the best,
Hal

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

99 views 1 10
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