Here is a version which uses CONVERT to allow using the yyyy-mm-dd format. This makes the code independent from SQL Server installation flavors.

Ralf

-----

DECLARE @date datetime

SET @date = CONVERT(datetime, '2003-12-31', 120)...