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

wsuhenda
Météoroïde

Honestly, this was not easy at all, despite initially seeming otherwise. The syntax for RegEx took awhile for me to grasp and even then, I feel like I'm just scratching the surface. Had to use Multi-Row formula to get output in the same order as the solution. Also completely bungled up on IF THEN ELSE syntax in the middle...not the best, but at least I can honestly say I did this without looking at other users' solutions.

Bren_Spill
Bolide
Révélation
#4 WF.JPG

Raj
Magnétar

Solved!

 

Challanges are always fun to solve.

ArnoldQ
Météore
Révélation
 
chirimoyayachay
Météore

it took me a while

beatriz_alteryx06
Astéroïde

Solved.

vmazur24052020
Astéroïde

4-steps solution

 

Révélation
Spoiler.png

 

CurtisPaterson
Astéroïde

Solved!

Jeffreyx
Météore
Révélation
Screenshot 2024-05-23 165402.png
Justindata
Météoroïde
Révélation
 
AlteryxCh4.png

Alteryx Convert to Date tool is quite forgiving!