Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
@DinoF, I will try to be more diligent with making more backward compatible workflows. Attached, I have a workflow that should work with your version. If you ever find yourself in a spot where you do not have a compatible workflow version, you can make is compatible (most of the time) by following this knowledgebase article.
Also, check out the "modify Alteryx workflow version" that @MarqueeCrew has posted on the Gallery!
I first identified and isolated the first character of the string, which denotes the year, using the simple left([date],1) formula. I then created a text input as a mapping table:
I then joined this table on the first character, then took the new year value. I then simply appended the year to the rest of the data string, effectively replacing the first character with the appropriate year value. Then I simply parsed the date.