Time zone descrepancy between WBS Gantt Chart and exported excel

Question

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

VPN担当者 · Answer

Hello @Y_H ,

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

All the best,
Hal

Y_H · Answer

Hello @VPN担当者 ,

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

VPN担当者 · 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