The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.

You get this error because you are trying to query with a date not supported by SQL Servers SmallDateTime datatype.

Note that SmallDateTime only allows dates between

January 1, 1900, through June 6, 2079

When you required dates beyond this range to be stored off in the DataBase specify the Datatype for the field in the table as DateTime instead of SmallDatetime