Thanks for your reply. Will check this out.

So this Strict Mode was implemented just recently?


>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.