Skip to main content

Zapier seems to format dates wrong when writing to google sheets.

It converts this 

into this

If I switch the 2 top with 2 bottom I get the same result. I have even tried having the columns around the table, I still keep getting 2 of the dates parsed wrong.

This is extremely frustrating, and makes me unable to enter more than 2 dates properly.

 

EDIT: Adding a fake row with correct format seems to have fixed it...

Can also set the format of the column values in GSheets