Use column info as template
I think you will have an easier time to simply cast whatever the user throws at you to a date format that you want, to keep it all uniform. E.g. in PHP like this: date('Y-m-d', strtotime($userdate))

It can also be done in sql with convert(date, '28/09/2016'), however I think you need to specify the format. Link