DataAssist date field is not updating correctly
I am using a MySQL database and the field type is set to DATE. Whenever I try to change the date, using DataAssist, it comes back to me as 0000-00-00. It's not updating correctly. The Update Option Data Type is being set to Date, within the DA wizard. I've never encountered this before and I'm not sure how to fix it...???