Best answer

Zappier parses the date wrong when posting to google sheets

  • 7 October 2020
  • 1 reply
  • 103 views

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...

icon

Best answer by Troy Tessalone 7 October 2020, 19:15

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Can also set the format of the column values in GSheets