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

[Will Davis]

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? 

[Mariana_Pryshliak_Saasjet]

Hello @Will Davis 

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

[Will Davis]

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.