Question

How do I keep the DD/MM/YYYY date format when creating Trello cards from Google Sheets?

  • 8 January 2024
  • 1 reply
  • 50 views

Hey there, brand new to Zapier and I am trying to get entries from Google Sheets to create cards on Trello.

Here is the current flow of my Zap:

  1. Trigger: new row in Google Sheets. Date in spreadsheet is DD/MM/YYYY
  2. Create card in Trello (this ends up setting the date as MM/DD/YYYY)
  3. Date/Time in Formatter (to source the date from the spreadsheet again and to add HH:mm after the DD/MM/YYYY)
  4. Update Card in Trello

Here is the format modification

Updating the Trello card

However the date remains as MM/DD/YYYY

Am I missing something?


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

Hi @helicopterrave 

In the Formatter step, the To Format and From Format are the same, so you need to adjust the To Format.