Hi,
I'm having a bit of a nightmare with date formatting.
I currently have a zap from a google sheet (auto generated from a google form) to Trello which creates a new card when there is a new row on the sheet.
The google form is taking a deadline from my customers in DD/MM/YYYY format.
My Trello is displaying DD/MONTH format which should match the form information however Zapier is switching the month and the date around for example:
Google form date: 06/10/2023
Trello card deadline: 10 June where it should be 6 October.
I understand that its because Zapier only works in MM/DD formatting however I have changed my language in Trello to be US to match Zapier but this isn't resolving the problem.
I don't want to use formattier as this adds another step not available to me without upgrading my Zapier account.
Anyone have any tips?
