community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #4: Date Parsing

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).

Meteoroid

Just starting out with Regex. This was fun practice!

 

 

Spoiler
clipboard_image_0.png

 

 

Meteor

My Solution:

Meteoroid

 

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

 

 

Meteor

Definitely the long way but it works!

Here is my solution !

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.

 

 

Asteroid
 
Meteor

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