About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

  • 5 July 2023
  • 4 replies
  • 35 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
Userlevel 7
Badge +6

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

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

SamB
Rank
Userlevel 7
Badge +11

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 & Conditions