Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Chantelbbr
8 - Asteroid

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
13 - Pulsar

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.

 

 

zuzannaf
8 - Asteroid
 
ejparth
7 - Meteor

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