Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi, Still learning about Date formatting. This was a great exercise for me. I was determined to complete it without reviewing solutions. When I started, I first went to my comfort level of using filters and basic formulas, and I obtained the expected results. I then practiced my DateTimeParse formula. Confidence is building a bit. So then I braved it to try the RegEx tool. All of the work streams are attached. After I completed my various streams, I reviewed solutions. I feel good that I was applying similar approaches. :)
Two methods. One with a long calc and another with a slightly less long calc. Solution attached.