Extracting date from char variable

[vanaja]

Hi,
The users are entering "date" value in a "character" column. So, they may not follow "dd/mm/yy" format correctly. So, i want to validate the "data" inside "char" field is a proper date. Pls advise.