Hi,

because it's enable strict mode:
https://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime/36374690#36374690

MartinaJ

>Hi All,
>
>I cannot seem to put my finger on this situation. In a previous MySQL version, 5.7.27, it accepts blank VFP dates and populates the MySQL table with '0000-00-00'.
>
>Now with 5.7.40, it says "Incorrect date value".
>
>I am using ODBC 8.0.
>
>TIA.