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 #58: An Odd String to Date Conversion

ZacharyRyanTIL
8 - Asteroid

solved

ahsanaali
11 - Bolide

ahsanaali_0-1662186513089.png

 

karlhansen
9 - Comet
Spoiler
solution_58.jpg
pmyers
Alteryx
Alteryx

My solution attached.

Ruban
8 - Asteroid

Formula:

IF Left([date], 1) = "1"

THEN Replacefirst([date], Left([date], 1), "20")

ELSE ReplaceFirst([date], Left([date], 1), "19")

ENDIF

Krzysztof_Ch
7 - Meteor
Spoiler
Krzysztof_Ch_0-1663239875953.png

 

RMdL
7 - Meteor

This challenge is the same as challenge 46 no? Like same file and all! 

 

RMdL_0-1663670287146.png

Spoiler
RMdL_1-1663670319660.png

 

 

gupta_sahil
8 - Asteroid

Here is my solution.

paul_houghton
12 - Quasar

Going Fancy in a single tool answer with regex, for the lols

 

Spoiler
challenge_58 Completed.png

Carolyn
8 - Asteroid

Solution attached. I did both a formula DateTimeParse and the DateTime tool, to practice both