Streaming live at 10am (PST)

Value is not a valid date string


#1

I'm trying to import some event-data within a google sheet via zapier into a collection of webflow. Works great exept for the field "date". In Google the field is formatted as Date/Time:

1/1/2017 13:15:00

But zapier returns an error:

api.webflow.com returned (400) Bad Request and said "Field 'start-date-time': 
Value is not a valid date string: '1/1/2017 13:15:00'"

Any idea, how I have to modify the date-field in my google-sheet?

Nine


#2

We use the date format defined by ISO 8601 (https://en.wikipedia.org/wiki/ISO_8601). It's limited to just this format as accepting multiple date formats gets tricky since, as an example, there is no way to know if 2/1/2017 is Feb 1st or Jan 2nd.

So for your example date, the format would be: 2017-01-01T13:15:00.000Z


CMS Date Formatting Trouble