Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAInteresting solution. Much simpler than I used
Used Text to Columns followed by strip quotes function, parsed the date then dropped an renamed columns using the select tool.
Fun.
My key takeaways from this challenge
1.Learnt to Trim Characters from the Dataset
2.Learnt to convert Date Format