title: assign marking period name based on dates in table
body: <p>I have a table with three columns: the start and end dates for each reporting period and the name of the period. I have a second table with a bunch of dates. I'm trying to create a third table that has the date from the second table with the name of the marking period from the first table.</p>
  
  <p>I know I can do this by hard coding the dates from the first table into a bunch of CASE statements. Is there a better way?</p>