It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I change this date format?



I working on a zap between Google Sheets and Trello. Google Sheets is using the Timzone GMT with a date format DD-MM-YYYY. When the row is converted into a card in Trello, the due date converts it to MM-DD-YYYY if DD < 12. I'm using Zapier to connect this two tools and already made changes in the date format Trello is expecting in the API connection (YYYY-MM-DDTHH:mm:ssZ).


My question: Why is Trello switching the format in due date and how can I fix it? My timezone is in Amsterdam (GMT+1). 


Thank you in advance! 


KR, Mark  

1 answer

0 votes
David Bernal Atlassian Team Feb 11, 2020

Trello's API uses the standard ISO 8601 date format, which is the one you mentioned "YYYY-MM-DDTHH:mm:ssZ". This is the safest format to use with our API, since it's standardized. This format will operate correctly with many other systems. The API will attempt to interpret dates in other formats, but since date formatting depends on locale, it's not always guaranteed to be correct.

Perhaps if you're using Google Sheets and Zapier, they might have a way to transform dates from your format into this one, and vice versa?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,616 views 15 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you