Zapier seems to format dates wrong when writing to google sheets.
It converts this
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/18b1527a-c379-45cf-af0e-d3de04d2bb9e.png)
into this
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/84d4804d-9fbc-4d55-ae68-11d8c7177cec.png)
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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/82fa7580-a7cf-4a92-8bf1-f82cbfafb1f1.png)
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...
Best answer by Troy Tessalone
View original