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.

I am building a zap to trigger a new row in MySQL when I create a new record in Adalo. My issue is that Adalo stores their date in the format YYYY-MM-DDT00:00:00:000Z and MySQL store it as YYYY-MM-DD. 

 

As a result, I’ve created a zap action to change the format of the date input to one that works with MySQL.

 

The following two screenshots show this process in action with the date input, and the finished test with final date output.

 

I have set up the final step to populate the Date Created column in MySQL with the date output from the reformatting step (now it’s in the form YYYY-MM-DD)

However, when I run the final step I still receive the same error that the date created in MySQL cannot be of the format YYYY-MM-DDT00:00:00-05:00. The new row sent to MySQL shows a Date Created with the format YYYY-MM-DD. Any advice on how to address this issue and have the date formatting allow for a successful zap build is greatly appreciated.

 

@Henrikcox 
Unfortunately, i think this could be considered a bug in the MySQL integration. Since the date_created field is a date field in Zapier, Zapier does some data manipulation to whatever you type in there to ensure its a date object prior to sending it in the request

I am curious though since it is a ‘date_created’ field. Is it required to send with your request or can MySQL automatically calculate it when the new record is created?

Hi @Henrikcox 

Try specifying a From Format:

 

Hi @Troy Tessalone, I just went ahead and tried filling the From Format input in the Date formatting action step. Unfortunately, it still seems like the end resulting error pops up, even when it looks like MySQL is being populated with the date in the format it wants to see it in.

 

 

Thank you for the insight @GetUWired; we have our MySQL table set up that unfortunately a new record for this collection does require a date created. If this field is blank it simply returns the error down below. I’m not sure if MySQL can calculate this automatically in any way.

 

@Henrikcox 

Might want to try opening a ticket with Zapier Support about this: https://zapier.com/app/get-help

Will do, thank you @Troy Tessalone 

Hi there, @Henrikcox! Thanks for reaching out!

I can see you’ve reached out to support, which is perfect. Please keep us posted! We’d love to hear any solutions ya’ll are able to uncover together.

Terms & Conditions