select * from theTable where date( year( ldStart ), month( dob ), day( dob ) ) between ldStart and ldEnd