I am trying to import some tables and they all seem to have the same issue with the date format. It is a MySQL 8 DB in DigitalOcean and in the database the date is stored in this format YYYY-MM-DD, However when attempting to import the preview screen shows the data as DD/MM/YYYY hh:mm:ss. and when the import is run with the "Skip Corresponding Rows" on Import Error setting all the data in the date column is empty. 

When I attempt to change the date format to match what is seen in the database I get the following alert in the preview screen "The chosen format is not compatible with the column values. Are you sure, you want to apply the selected format?" 

Is there a way to fix this issue and get the data imported correctly