Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALooking forward to looking at the solution for this; it seems a little unintuitive/clunky to me to have to duplicate the rows to do a between clause when in SQL it'd be a single line of a between clause. I toyed with the idea of the advanced join macro but couldn't get it working... oh well.
My favorite part of this was coming up with the formula in the generate rows tool (shown in the spoiler).
2 challenges down; 119 to go! :D