check constraint for date

Question

I need a check constraint for date so no data can be entered after today's/this date.

please advise thanks all

Answer 1

Try this:

ALTER TABLE yourTable
ADD CONSTRAINT yourDateTimeColumn CHECK (yourDateTimeColumn < GetDate() );

Answer 2

To remove the time part on SQL Server 2008, use cast...date

Also, I assume you can have dates including today

ALTER TABLE yourTable
ADD CONSTRAINT yourDateTimeColumn CHECK (
    CAST(yourDateTimeColumn as date) <= CAST(GETDATE() as date)
     );