I’m using Zapier to create a new record in one of my bases. The Zapier web hook is sending a date and time that looks like “2017/05/12 7:07:51 PM”. I have a datetime field in my base that receives that data, but it gets converted as though the incoming datetime is in the GMT timezone. My Zapier task history shows that record created in Airtable has “2017-05-12T19:07:51.000Z” in that field.
I tried pasting “2017/05/12 7:07:51 PM” directly into the field in my base, and Airtable uses my local timezone instead of thinking it’s GMT.
Is this a bug? See below for screenshots from my Zapier task history.