DELETE FROM table1
WHERE person_id IN (
SELECT person_id FROM table2 WHERE date = targetvalue)

You might want to get the book "The Practical SQL Handbook" it will be of great help in learning SQL.

-Mike