Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Airtable API Date ISO format

Topic Labels: API
958 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Has anyone experienced Airtable doing strange things with dates… it appears there is an invisible conversion happening…

I have a string ‘2019-12-13T15:00:00.000Z’

I pass it via airtable API check this out

to a date field with time… = “12/13/2019 . 9:00 AM” ( Include timefield is on… GMT is off )
to a string field next to it… = ‘2019-12-13T15:00:00’
When I copy the string field to a new table and change the type to date I get the correct date and time… the only issue is when sending a valid string to a datetime column it adds some sort of offset… See screenshot

The Calendly Start Event time is wrong… All 3 columns are fed the exact same datetime string to the airtable API
08%20PM

0 Replies 0