sql constraint to check date less than current date
snippet in sql

sql constraint to check date less than current date

user9016

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