Afternoon all,
I am fairly new to Alteryx and trying to deal with some dates that are variable in their formatting. The dates generally occur like this:
1-2 digit month, 1-2 digit day, and a 4 digit year. I am trying to parse out the month, day and year into seperate fields and then recombine them so that they appear in this format:
2 digit month - 2 digit day - 4 digit year.
Then I plan on putting the column through the date time parse tool by converting a string to a date time value.
I have been trying a series of left, right and substring functions to solve this problem but nothing seems to work 100% consistent. Regex is a bit abstract for me at this point so this switch to understand this concept in my head has not really "clicked".
Any help would be much appreciated.
Thank you,
Scott
