Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #4: Date Parsing

Highlighted
Meteoroid

I took a slightly different tack from the posted solution (still haven't waded through that RegEx!) -- wanted to be able to handle other likely date formats (e.g., 12-14-58, 9/9/91, January 4, 2001) -- the posted solution won't handle these. Also wanted to allow anyone in the future to convert two digit years to the most likely four digit years even if they use this years from now, so used a DateTimeNow (so if you run this in 2045, 12/14/30 will convert to 2030-12-14).

Asteroid

Just starting out with Regex. This was fun practice!

 

 

Spoiler
clipboard_image_0.png

 

 

Highlighted
Asteroid

My Solution:

Highlighted
Asteroid

 

Spoiler
Feel like I cheated a bit here because I had to steal the RegEx code from the solution. From there I created a single formula to move all the dates into a single column and then used the BB Date Tool (which everyone should download) to do all the date formatting for me. 



Oh well, all roads lead to Rome, I guess. challenge_4_solution_BL.png

 

 

Highlighted
Meteor

Definitely the long way but it works!

Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
Alteryx
Alteryx

RegEx had me scratching my head quite a bit on this one

Highlighted
Asteroid

Completed, I have used DateTimeParse in the formula tool.

 

 

Highlighted
Asteroid
 
Highlighted
Meteor

solution.... nice challenge ...learnt so many tools