Check and fix incorrect data, isdate function can help you.

Change data type to datetime if you can... Avoid cast() in where clause: It is a performance killers!