community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #46: Formatting a Date from an Integer

Asteroid

Here's my solution - similar to what many people had.

 

Spoiler
bjkay30_0-1574802062414.png
Alteryx Partner

46_Sihle.PNG

Asteroid
Spoiler
Challenge 46 2019-11-29.jpg
Asteroid

My Effort. Not many moving parts!

 

Spoiler
JamesCameron_0-1575039689012.png
Alteryx
Alteryx

Im sure i could of done this easier but hey

Meteor
 
Asteroid

Solution attached.

 

Spoiler
aihnen_0-1575388334703.pngaihnen_1-1575388356781.png

I did it with ONE formula tool

Spoiler
ToDate(If left([Date],1) = '1' Then '20' + Left(Right([Date],6),2)
ElseIf left([Date],1) = '0' Then '19' + Left(Right([Date],6),2)
Else "Error" EndIf+'-'+Left(Right([Date],4),2)+'-'+Right([date],2))

sonyakasenkramer_0-1575410919267.png

Alteryx Partner

here you go..

Spoiler
ozdogand_0-1575429983175.png
Alteryx
Alteryx

First time to use the function: ReplaceFirst(Str, Target, Replacement): Alway great to add another one to the collection