Problem with Zapier Formatter to New Row MySQL "(pymysql.err.OperationalError) (1292, "Incorrect date value..." error

Hi ​@jasch 

In your Formatter step screenshot, you have the wrong FROM Format selected compared to the format of the Input variable value (MM/DD/YYYY):

​@jasch 

For us to have more context, post screenshots showing how your Zap step is configured in EDIT mode with the field mappings visible for the MySQL Zap step.

Thank you, here is what you are asking for. The output shown in the image is exactly what I was hoping for but when its added into mysql it’s trying to add the time portion. I don’t think it’s the database because when I manually enter what is shown in the image it takes the data. 

​@Troy Tessalone I was under the understanding the the from input is to show what the variable is to look like coming into Zapier. This is the correct format for what is coming into Zapier Formatter MM-DD-YYYY, the To format I want it to be the opposite YYYY-MM-DD. You can see this in the last image I provided. The formatter seems to be working except for how it is being input into MySQL (with the time portion)

​@jasch 

TIP: Click field label to see tooltips with more info that may provide guidance.

Help links for using MySQL in Zaps: https://zapier.com/apps/mysql/integrations#help

If you suspect this is an error, you can try opening a ticket with Zapier Support: https://zapier.com/app/get-help

​@Troy Tessalone I’m confused. I have clicked the icons which is how I formatted everything. You mentioned that the value input and From Format are incorrect. From Format suggest “If we incorrectly interpret the incoming (input) date, set this to explicitly tell us the format. Otherwise, we will do our best to figure it out.” Input is MM-DD-YYYY | From Format = MM-DD-YYYY. How is that incorrect?

​@jasch 

The Formatter config is a separate issue from the MySQL step.

Field: Input 

Value: MM/DD/YYYY

Field: From Format

Value: MM-DD-YYYY

Since these do not match, there can be discrepancies with the value returned from Formatter.

​@Troy Tessalone but the formatting does match. That’s not why I’m not understanding what you are referring to. I agree the output from zapier to mysql does not seem to be correct even though the output from the formmater is showing correct in Zapier.  So Format output is correct as far as field mapping in Zap, when zapier integrates into mysql the format is not as it’s showing in Zap.

​@jasch 

NOTE: This feedback is merely to help you understand the Formatter config discrepancy, which is a completely different issue than the MySQL Zap step.

For the Formatter config, take a look at the screenshots below and the info outlined below and you will see the 2 data formats mentioned do NOT match.

Field: Input 

Format: MM/DD/YYYY

Value: 08/29/2025

Field: From Format

Format: MM-DD-YYYY

Value: 08-29-2025

Feedback from AI:

The discrepancy is that the input date is formatted as 08/29/2025 (with slashes, MM/DD/YYYY), but the "From Format" setting is incorrectly set to MM-DD-YYYY (with dashes).

This mismatch can cause parsing errors or incorrect date conversions in Zapier. To resolve it, update the "From Format" to match the input format: MM/DD/YYYY.

​@Troy Tessalone oh wow I see what you are sayying usin xx/xx/xxxx vs xx-xx-xxxx. yes thank you I corrected that now. But the error is still being thrown when trying to input into MySQL. Darn it. Do you think it has to do with my set up with Zap and MySQL? I’m doing other inserts into the same table it’s only the date format that is throwing the error even though I have the MySQL column set to date in database design.

​@jasch 

For the MySQL Zap step, it may be a bug with how the MySQL Zap app integration is configured.

You can try opening a ticket with Zapier Support: https://zapier.com/app/get-help