Converting a VARCHAR date to a VARCHAR date get's you nothing... you must first convert to DATETIME.
Also, storing dates as VARCHAR in a table to start with is a form of "Death by SQL".
--Jeff Moden
Change is inevitable... Change for the better is not.