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 am importing data from Thinkific to Zoho Creator via Zapier.

I had to re-format the date/time stamp for COURSE ENROLLMENT DATE using formatter because the date structure was not recognised by Zapier.

I changed the format YYYY-MM-DDTHH🇲🇲sssz (which goes to milliseconds) to the format

YYYY-MM-DDTHH🇲🇲ssz, which Zapier recognises, and set the output format to DD-MM-YYYY. Please see the screenshot below. This appears to work, and the output is correct. See second image.

 

 I then moved onto the Zoho ‘Create form’ and set the COURSE ENROLLMENT DATE  to pick up the output from the formatter step.

I replaced the original unrecognised date format with the output from the formatter trigger. See next 2 images:

 

But when I run a test, I am getting the error message  3002 - ‘Enter a valid date format for COURSE ENROLLMENT DATE’. The receiving Zoho form is set to receive a date in the format DD-MM-YYYY. 

I can’t work out why this is happening. Do I need to put an extra step in?

Thank you

Hi ​@Coachbase Training 

Most apps will expect dates in this ISO format: YYYY-MM-DD

TIP: Click the underlined field label to see a tooltip with more info that may provide guidance.

Hi ​@Coachbase Training 👋

Did converting the date into the ISO format Troy suggested do the trick?

Let us know how it’s going, want to make sure you’re all set! 🙂

Hi. Converting to that format is what I was trying to achieve, and was the problem I was having. I did resolve it by adding a formatter trigger to replace the unrecognised sssz millisecond format to ssz seconds format, then added an output format of DD-MM-YYYY

That’s great news ​@Coachbase Training! We’re glad to hear that using Formatter by Zapier resolved the issue here!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Terms & Conditions