I really need some help on the current date issue that I am having.
I created a field in MySQL under TEXT format and stored my date there (DD/MM/YYYY). I know it's stupid to do that, but I did it and didn't think of it at that time.
Anyway, currently I need to sort the dates and could not figure out a way to convert those dates into SQL readable format (YYYY-MM-DD). What can I do? Does anyone know how to convert a TEXT field (DD/MM/YYYY) to the SQL readable format?
I seriously need help. If anyone out there knows how to do it, please help me out. I'm extremely desprate here!
By the way, I am programming in PHP. Thank you for your help!