Is the date a valid date, are you doing validation?
How are you passing the date in, can you give an example?
Look at the range below
Date and time data from January 1, 1753 through December 31, 9999
Date and time data from January 1, 1900, through June 6, 2079
“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/