Best answer

Date formatter not working when sending to Zapier table

I have set up a zap to run data into a new Zapier table row.

I am in Australia and we use the date format DD/MM/YYYY

I have formatted the date correctly and tested it.

I have formatted the date correctly in Zapier tables column setting.

I have tested it and it is correct.

However, when I send the correctly formatted date to the table, it shows as incorrectly formatted. MM/DD/YYYY

Best answer by Troy Tessalone

Hi @Scott-B

Try sending the data to the Zapier Table using the ISO Format: YYYY-MM-DD

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

+14

Hi @Scott-B

Try sending the data to the Zapier Table using the ISO Format: YYYY-MM-DD

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor

That worked, thank you!

+6

That’s awesome @Scott-B! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Sign up