Zapier/API Date Format

Design help Data API
1

Hi all,

I’m having trouble importing a date from a Google Spreadsheet to Webflow live item via Zapier. I’ve tried several date formats, but they all return “ValidationError: Validation Failure” errors. Everything I’ve tried does seem to work through CSV import, so I’m stumped.

What doesn’t work:

  • MM-DD-YYYY
  • YYYY-MM-DD
  • YYYY-MM-DDT00:00:00.000Z
  • YYYY-MM-DDT00:00+00:00

Can anyone let me know the right date format to input?

Thanks!

2

Supported date and time formats can be found here: Date and Time Formats

Edit, hmm you seem to have tried formats that should work. Out of curiosity have you looked at exactly what Zapier is outputting to Webflow? Can you post an example timestamp?

3

That’s weird, the YYYY-MM-DDT00:00:00.000Z format should work.

Can you try PowerImporter’s CSV Import instead? In my experience, it supports almost any date format. Either way, it will generate a detailed log if Webflow’s API returns a validation error.

4

I’ve tested the same spreadsheet as a CSV import and it works fine – unfortunately was hoping to use Zapier so that our large number of collaborators could update information on their schedules, so the PowerImporter tool isn’t right for that purpose even if it works.