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.

hi, I have an issue with dates in Zapier.

I have created a Zap to link Jotform and ZohoBooks.

I am a dogminder and the invoice date is the drop off date in the Jotform

The invoice due date is the collection date.

I have no issue with the first date, but the second date it’s mixed up.

see screenshot:

In Jotform, the date is DD-MM-YYYY format:

 

In ZohoBook invoice it becomes MM-DD-YYYY+1yr (should be 12 September 2023)

 

I am at a loss on how to put it right. any advice? thanks, R

Hi @Resi 👋

It’s very odd that it’s adding a year. I wonder if it’s adding a year to the date of the due date because 12 September 2023 is a date that’s already passed? 🤔 Perhaps ZohoBooks doesn’t allow for back-dated invoices to be created via it’s API. 

With the day and month being switched around it could be that ZohoBooks is expecting to receive the date the MM-DD-YYYY format that it’s converting it to. In which case it might help to use a Formatter action to convert the date from DD-MM-YYYY to MM-DD-YYYY and then use that converted value in the ZohoBooks action. That should help to get it interpreting the dates correctly. You can learn more about how to use Formatter to convert date values into different formats here: Modify date and time formats in Zaps

Hope that helps to get you pointed in the right direction. If you run into any trouble on that or if there’s anything else I can assist with do let me know! 

Reply


Terms & Conditions