date formatting issue

[Ashleigh Pead]

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?

[Daydreamer Mike]

Hi @Ashleigh Pead 

Welcome to the community.

Try following this guide:

https://support.atlassian.com/trello/docs/turning-on-international-timedate-formatting/ 

[Ashleigh Pead]

Hi Mike.

Thank you. I have tried this with both English UK and English US settings to no avail. Trello remains in English UK regardless..,

[Daydreamer Mike]

To diagnose further, map the date field from your google form to the description field in Trello and see how it is coming into Trello. Paste what you get here when you are done...

[Ashleigh Pead]

[Ashleigh Pead]

First photo is the google form. Date remains in that format (UK) until it reaches Trello via Zappier, and then the day and month is switch over, even though Trello remains in UK format. I've switched trello from UK to US and back, and it made no change to the date format within Trello

[Daydreamer Mike]

Did you set up the zap?

[Ashleigh Pead]

Yes this Zap has been running for over a year 

[Daydreamer Mike]

To be able to help more from the Trello side, I need to know what Trello is receiving from Zapier.  Can you do a test by copying the Zap and mapping the date field from the Google Sheet to either a text custom field in Trello, the Description or post a comment.  

Once I know what format the date is coming into Trello in, I may be able to help more