Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #46: Formatting a Date from an Integer

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

Inefficient but it works!

Highlighted
8 - Asteroid
Spoiler
43poza.png
Highlighted
8 - Asteroid
Spoiler
challenge_46_RC_solution.PNG
Highlighted
8 - Asteroid

Here's my solution!

Spoiler
Capture.JPG
Highlighted
7 - Meteor
 
Highlighted
7 - Meteor

Solution attached

Highlighted
8 - Asteroid

Solution attached

Highlighted
8 - Asteroid

 

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.

 

8 - Asteroid

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

 

Spoiler
RL_Challenge_46.png