varchar to datetime

[Bell1991]

I have a column that is a varchar and i need to convert it to datetime and insert it into a table.

I have:

Insert into tblA (dtDate)
Select cast(dtEmployeeDate as datetime) from tblB

I am getting the follwoing error:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.


any suggestions