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.