Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
Using two RegEx statements to find the numbers and possible months, before using a Find/Replace to clean the months (using a simple text input of JAN, FEB, MAR, etc), a formula to get the correct 4 digit year and then joining it all together....
Only attaching for historical sake, had to copy my solution. New to alteryx and only going through these to learn! Hopefully around challenge 100 I'll have more of my own answers 😂