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.
Best answer by Troy TessaloneView original