Google form to Trello via Zapier. I need help with the 'Due Date' format in Trello

Question

I have created a google form asking various questions and set a due date on UK Date formatting: DD/MM/YY

Via Zapier, my Google form responses create a card on Trello.  All dates noted on the form are coming across correctly: DD/MM/YY, except the 'Due Date' one.  It keeps formatting it to MM/DD/YY.

The due date is vital for success of the projects - can you please advise where I am going wrong?

Please note, I have UK Time Zones selected for all: Google Form, Zapier & Trello already.

Iain Dooley · Answer

@Patrice O'Hagan Okay so in your original post you said:

Via Zapier, my Google form responses create a card on Trello.  All dates noted on the form are coming across correctly: DD/MM/YY, except the 'Due Date' one.  It keeps formatting it to MM/DD/YY.

The due date on the card doesn't have a "format" as such -- like, it doesn't display as "MM/DD/YY" it displays like "11 Nov" and if the due date is in a different year it will display like "11 Nov 2020".

So are you saying that when the due date is set on the card to the value submitted in the form, the value set on the due date would be correct if the form input were interpreted as MM/DD/YY instead of DD/MM/YY?

What I mean is that if in the Google Form you enter the date as:

10/12/19

the due date on the card will be set to 12 Oct instead of 10 Dec?

Patrice O'Hagan · Answer

@Iain Dooley

I mean the cards due date is being set.

Iain Dooley · Answer

@Patrice O'Hagan okay when you say "due date field" in Trello do you mean:

- The card's due date is being set

- A date type custom field is having a value set or;

- A text type custom field is having it's value set