ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
I really like seeing how others have solved this problem. My solution used a lookup table and managed months by identifying January with a mod function, then bringing month data in. I like how others have used the date parse tool.
After reviewing the solution, I realized that I took the long way around, but I did manage to get the correct answer. Here is my solution to the challenge.