Jira Cloud for Sheets Timezone Question

[Travis Spackman]

When I import data using Jira Cloud for Sheets, what Timezone does it use when you include any type of date/time fields?   I've tested this and it's not using my current timezone.  

[Dan -minware-]

Hey @Travis Spackman -

I found this older thread that might help:

https://community.atlassian.com/t5/Jira-Service-Management/Jira-Cloud-For-Sheets-exports-data-in-a-different-time-format/qaq-p/1289496

This was a known bug from 2020 and it's unclear to me if it's been resolved. Hopefully this at least points you in the right direction!

[Aron Gombas _Midori_]

I don't know the precise answer, but properly written software should differentiate between the data and its display.

In this case, I'd expect that times are normalized to a predefined timezone (most software are using UTC), then you can choose the timezone in which you want to display the values.