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!
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?
If you had to thrive a new habit during a lockdown, what would it be? Trello
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