First thing, always use the correct data type to store data.

You could query the column and use ISDATE()

UPDATE <TableName>

SET <ColumnName> = NULL

WHERE ISDATE(<ColumnName>) = 0

You could then CAST or CONVERT your text data to a date data type

Andrew SQLDBA