I solved the problem - the date format was still set to an MSAccess Date. I changed the format to just date - then I had to go to the MySQL database and change the data type from datetime to just date. Then I had to change the input format on the date field to yyyy-dd-mm
Tried again and it worked okay!
Thanks for your encouragement!