Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Day and month in Due date being swapped over when sent to Trello

  • July 5, 2023
  • 4 replies
  • 83 views
JordanSSP

I use zapier to add cards in trello from Smoobu. This is triggerd by smoobu sending a email to zoho mail with the date in the description displayed as 07/07/23. (7th July 23).

This is working most of the time but at the start of each month the date is reversing so 10/06/23 would push through to trello as 6th October.

How do I get around this issue? The system that has been built to automate most of our proccesses will be resolved with this issue fix. 

Thanks in advance 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • July 5, 2023

Hi there @JordanSSP,

Welcome to the Community! 🎉

I’m so sorry for the troubles with your Zap.

Before we dive deeper, could you please send a screenshot of Zap run in your Zap History that shows this behavior? Especially, the Data In and Data Out section of the Zap run.

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thank you! 😊

JordanSSP
JordanSSP
  • JordanSSPBeginner
  • Author
  • Beginner
  • July 5, 2023

 

JordanSSP
  • JordanSSPBeginner
  • Author
  • Beginner
  • July 5, 2023

it seems to be switching the date which is sent over like the desc but shows different in the due date 

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • July 6, 2023

Hi @JordanSSP! 

Hmm, it seems like Trello isn’t interpreting the date correctly. It appears to be reading it as MM/DD/YYYY instead of DD/MM/YYYY and sending it as YYYY-MM-DD.

What might help here is to convert the date into the same format that Trello is sending it in (YYYY-MM-DD). To do that you’ll want to add a Formatter (Date / Time > Format) action to convert the date being sent over by Zoho Mail. Then in your Trello action, in the Due field you’ll select the converted date from the Formatter action instead.

If you’ve not used that kind of Formatter action before I’d recommend checking out our Modify date and time formats in Zaps guide for more details on how to set it up.

Hope that helps to get you pointed in the right direction. If you run into any issues in setting that up just let us know and we’ll be happy to assist! 🙂

Terms & ConditionsAccessibility statement