Join by date range

The first solution that came to my mind:
The Cross Joiner node and then the Rule-based Row Filter node with this expression:
$Date$ >= $Start_Date$ AND $Date$ <= $End_Date$ => TRUE

If cross joining is not a good approach in your case then let me know and I will try to come with a better idea.

:blush: