SELECT member_id FROM tbl_member WHERE member_date BETWEEN date('YYYY-MM-DD') AND date('YYYY-MM-DD');