I'm wondering how best to add a constraint for a date field that cannot be a future date and cannot be declared earlier than a specified date. Here's a simplified table structure. I'm using MYSQL.

create table(
id int(11) not null auto_increment primary key,
name varchar(55) not null,
dob timestamp
)