Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #4: Date Parsing

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

Chantelb
9 - Comet

Just starting out with Regex. This was fun practice!

 

 

Spoiler
clipboard_image_0.png

 

 

sachinw
8 - Asteroid

My Solution:

Billigans
8 - 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

 

 

JSchiele
7 - Meteor

Definitely the long way but it works! 🙂

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

ArnavS
Alteryx
Alteryx

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

Kaviyarasan_P
8 - Asteroid

Completed, I have used DateTimeParse in the formula tool.

 

 

Zuza
8 - Asteroid
 
Inactive User
Not applicable

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