In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
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.