You are getting an implicit conversion, expecting SQL Server to convert those integer values for you. As Jeff mentioned, you want to use quotes around dates to explicitly state the values are dates and not numbers.