Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHonestly, this was not easy at all, despite initially seeming otherwise. The syntax for RegEx took awhile for me to grasp and even then, I feel like I'm just scratching the surface. Had to use Multi-Row formula to get output in the same order as the solution. Also completely bungled up on IF THEN ELSE syntax in the middle...not the best, but at least I can honestly say I did this without looking at other users' solutions.
Solved!
Challanges are always fun to solve.
Alteryx Convert to Date tool is quite forgiving!