Covert all date data format from VARCHAR to DATE in any MySQL table

I am working on a project which was majorly developed by any otehr developer. My work is to update every module and add some functionality. This is a financial application...