CODE EXAMPLE FOR SQL

sql constraint to check date less than current date

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