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.

Best answer

Zapier date format issue: Thinkific to Zoho Creator enrollment date not recognized

  • June 18, 2025
  • 4 replies
  • 43 views
C
Forum|alt.badge.img

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:mm:sssz (which goes to milliseconds) to the format

YYYY-MM-DDTHH:mm: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

Best answer by Coachbase Training

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

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34072 replies
  • June 18, 2025

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.

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9736 replies
  • June 24, 2025

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! 🙂

C
Forum|alt.badge.img

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

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6780 replies
  • June 26, 2025

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 & ConditionsAccessibility statement