Lynn Pettis (8/20/2014)
As this was posted in a SQL Server 2005 forum the DATE data type is not available in this version of SQL Server.
The following check constraint should work in a similar way under SQL Server 2005.
create table #t
constraint ck_EndDate check (EndDate = convert(char(8),EndDate,112))
"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."