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

JamesMA
Alteryx Alumni (Retired)

Used a filter in this example. A similar challege to #46 so I went for a different approach.

 

Spoiler
James Marks Week 58.PNG
SueDonim
8 - Asteroid

Replay of Challenge #46

 

Spoiler
MySolution.PNG

 

 

Billigans
8 - Asteroid
Spoiler
challenge_58_solution_BL.png
blundebjerg
8 - Asteroid
 
kmalone007
8 - Asteroid

Solution

mat_budden
8 - Asteroid

Hi All,

 

Please find my Result below...

 

Isn't this the same as number 46??? 

 

Spoiler
Same as my Answer for Challenge 46. Formula all the way.

 

Thanks

Mat

RoDO
8 - Asteroid

My solution, Exactly the same as Challenge #46

 

Spoiler
Formula:
DateTimeParse(
IF Left([date], 1) = '1'
THEN '20' ELSE '19' ENDIF
+ Right([date], 6),
'%Y%m%d')
challenge_58_RODO_Solution.png
Steph3388
7 - Meteor

Was trying how to figure out how to do it in 1 tool, but this worked as well.

myouree
8 - Asteroid

My solution

T_Willins
14 - Magnetar
14 - Magnetar

Reposting to add spoiler (to get challenge tracker to work)

 

Spoiler
Workflow 58.JPG