Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Tested alteryx copilot on this
Congratulations! to top 15 users
Here is my solution!
Done (annoyed that I didn't start completing these challenges until after the data was culled, ha! I'll challenge myself to pull in new data :)
Spoiler
I created tables and used a visual layout so I could see the output of both tasks in the same place, it's not lovely, but it's lovelier than a multiple join (I think). I also had to subtract one from the date formula to match the results in the solution.... which does make sense so we're looking at between, but I wonder if there's not a better way to do that.
