Hi all
First time posting so hopefully I provide enough information. I’ve searched through the posts and found various date/time format issues but still haven’t been able to resolve my issue.
I have a google form which when completed updates a google sheet. New rows added to this sheet are then sent to create a new row in a database table in our SQL Server.
Column A is a timestamp in Date time format showing as DD/MM/YYYY HHss. The Data Out is showing this format correctly.
In the SQL Server step the Data In is still showing this format e.g.
11/11/2020 11:55:57
However the Data Out is showing it in format:
2020-11-11T11:55:57-08:00
I’ve tried adding a Formatter by Zapier step but this hasn’t helped. In this step it is showing correct data in and correct format out.
It seems to be changed during the SQL Server step but I can’t identify why. Can anybody shed some light?
Thanks in advance, help much appreciated.