Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAAll,
I used a bit of a waterfall method in my approach.
-First, two of the dates use hyphens (-), so I was able to use Tex to Columns to parse those, and then use left and right in order to gather the rest of the date.
-The third, used a comma, so I was able to parse the comma and then use Text to Column to grab the year and day on either side.
-Finally, I had to use Regex for the final date.
-Again, I have created my solutions to use a little custom code as possible.
-Cheers!
Matt
My solution uses more tools but there is less code and it is easier to understand - it leverages the power of the DateTime tool