In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start 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 #46: Formatting a Date from an Integer

msicak
8 - Asteroid

one-tool-cool. tried with replace first, without realizing there's a replaceFirst. ugh. still, one-tool solution achieved.

 

Spoiler
challenge46.png
BrendaS
8 - Asteroid

Another one done!

derekbelyea
12 - Quasar
Spoiler
2017-12-28_122259.png
blairmbailey
8 - Asteroid

Solution attached - thanks!

SGolnik
11 - Bolide
11 - Bolide

I am doing these out of order and since this one ended up being a duplicate to one I already did, I tried a different approach with this one by taking time to do the conversion all within the same formula.

dsmdavid
11 - Bolide

similar approach

 

Spoiler
46.png

 

david_elliott
5 - Atom

Two step formula approachTwo step formula approachReally enjoying getting more in to Alteryxs with the Challenges

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

TeePee
8 - Asteroid

My solution felt really inelegant and subsequent checking through other people's work reveals my baby-steps newbie approach.  But it still worked :)   And now I know better for next time!  Thanks again for these.  Very useful.

Ozzy_Campos
8 - Asteroid

Solution, pretty straightforward.