You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
Welcome to the community.
Try following this guide:
https://support.atlassian.com/trello/docs/turning-on-international-timedate-formatting/
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..,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you set up the zap?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.