Date within date range score

I have two tables, one has a date of when someone joined the team, the other has a rank (we use it for payments) but just a score value (single integer) with a start/end date for when that score is v...