Invalid character value for cast specification

If you catch this error and you are trying to use a DateTime Value with SQL Server then check that your date in this range:1/1/1753 to 31/12/9999