Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

date formatting issue

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?

1 answer

0 votes
Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 06, 2023

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..,

Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 07, 2023

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...

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

Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 07, 2023

Did you set up the zap?

Yes this Zap has been running for over a year 

Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 07, 2023

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events