Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATried to run different ways but always ended up on more long or complex solutions... ended up doing the same solution as suggested.
This one, I used the text to columns to do a first split,
then I used data cleansing on first two field to remove punctuation,
then I used a trim to remove the single quotes around the date.
Then I used the date time now to parse the date
and then I used select to rename and output the data.