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

RotesDB
8 - Asteroid
Spoiler
Challenge #46.png
CliffordC
Alteryx Alumni (Retired)

Inefficient but it works!

Ioana_Radoveneanu
8 - Asteroid
Spoiler
43poza.png
rcor
8 - Asteroid
Spoiler
challenge_46_RC_solution.PNG
Marcel_Gavrila
8 - Asteroid

Here's my solution!

Spoiler
Capture.JPG
Cumminsj2
7 - Meteor
 
AnnaG
8 - Asteroid

Solution attached

Nmetzgen1
8 - Asteroid

Solution attached

mbogusz
9 - Comet

 

Spoiler
2019-07-21 08_29_53-Greenshot.png

Tried successfully using the LEFT and RIGHT formulas plus a DateTime tool.  Then wanted to play catch-up with @TaraM's one formula solution and that worked too.  The Help Index was an invaluable resource to see where "%Y%m%d" came from too.

 

rslopez2
8 - Asteroid

Broke the formulas up in pieces as opposed to the original solution:

 

Spoiler
RL_Challenge_46.png