Jira to Google Sheets, the export is adding 2 hours to a date & time field, how do I resolve?

Question

When i export data from a filter using either Google Sheets export or Excel Export option the result is that the Date and Time field has had the time increased by 2 hours. Both app setting have the same time zone setting (Melb +10). The same issue can be replicated on various CPUs.

When i export to CSV (current fields) there is no issue, date and time are exported within any issue.

Does anyone know how to resolve this?

Will Davis_we6k5w · Answer

Hi Mariana,

I'm using the Google Sheets export tool (green icon below) or Excel export tool, which are great because the open in the browser. There are no issues when i use the "Export" option.

Mariana_Pryshliak_Saasjet_qysy8m · Answer

Hello @Will Davis

Tell me, please, which tool do you use for exporting? Did you write on support about this issue?