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 #46: Formatting a Date from an Integer

bjkay30
8 - Asteroid

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

 

Spoiler
bjkay30_0-1574802062414.png
Sihlex1
7 - Meteor

46_Sihle.PNG

danicahui
8 - Asteroid
Spoiler
Challenge 46 2019-11-29.jpg
JamesCameron
8 - Asteroid

My Effort. Not many moving parts!

 

Spoiler
JamesCameron_0-1575039689012.png
Kakuffo
Alteryx
Alteryx

Im sure i could of done this easier but hey

OliverJ
7 - Meteor
 
aihnen
8 - Asteroid

Solution attached.

 

Spoiler
aihnen_0-1575388334703.pngaihnen_1-1575388356781.png
sonyakasenkramer
8 - Asteroid

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

ozdogand
8 - Asteroid

here you go..

Spoiler
ozdogand_0-1575429983175.png
JWS
Alteryx Alumni (Retired)

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