Conversion failed when converting datetime from character string

This is most common error people found when messed up with type conversion.

You have DateTime field in DB. Now if you are using stored procedure then make the parameter as dbtype.datetime/dbtype.date and if you are using sql query try to use parameterized query and make the as dbtype.datetime/dbtype.date

When you are passing datetime from c# code, use Convert.ToDateTime().

Try it and let me know, if it solves your problem or not.

Thanks.....