Kevin Wilkie deals with not-so-datey dates:
Because of the “not-so-dateness” of the data, you cannot convert non-date items into a date, at least not with the CONVERT function.
“Not-so-datey” is, of course, a technical term. Read on to see what you can use as an alternative to CONVERT().