Free Trial

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

DeanLewis
8 - Asteroid

Nice, thanks!

 

Spoiler
DeanLewis_0-1647259876723.png

 

Reesetrain2
9 - Comet
9 - Comet

All,

 

Spoiler
Capture.PNG

Pretty straight forward as I used a Formula tool, a Date Time and the a Select to clean up.

sglynn14
8 - Asteroid

Solution

DataNath
17 - Castor
17 - Castor

My solution to #58. Found this to be the exact same as #46.

 

Spoiler
DataNath_0-1647423349921.png

 

tanyafischer
8 - Asteroid

solved :)

emartz
Alteryx Alumni (Retired)

Typical solution.  I did create a century variable to try and make things a little dynamic, but very simple workflow.

NikkiJain
7 - Meteor

Here's my attempt:

 

 

aantoni
8 - Asteroid

done

DanielvanLeuzen
8 - Asteroid

My solution

tim-bakker
8 - Asteroid
Spoiler
Date_out = DateTimeParse(If Left([date], 1) = '1' THEN '20' ELSE '19' ENDIF+ Right([date], 6),'%y%m%d')