Is there a way to join data on a date between a start and end date?
This is really a data flow question. I have assignments in one table that have a start and end date. I am trying to join this to daily activity.
set one look like
code start_date end_date
sm 1/1/2015 2/1/2015
asc 2/2/2015 6/2/2015
then there is daily activity and I need to see how much daily activity happened under each code...