Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

A_Twa
8 - Asteroid

I think I'm finally starting to understand datetime parsing in Alteryx....

MsBindy
8 - Asteroid

More steps than I needed.

nick_ceneviva
11 - Bolide

solution attached.

jamielaird
14 - Magnetar

Here's my solution, using just a Formula tool.

 

Spoiler
Screen Shot 2017-08-29 at 13.10.31.png
BenMoss
ACE Emeritus
ACE Emeritus

I went REGEX on this one.

 

Spoiler
datetimeparse.PNG
BenMoss
ACE Emeritus
ACE Emeritus

I went REGEX on this one.

 

Spoiler
datetimeparse.PNG
patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
data_rachel
8 - Asteroid
Spoiler
Like many others, I tried to do this in a different way from the other time (and in one tool). Got a lot more familiar with dateparse.

challenge46.PNG
marcreid
7 - Meteor

Solution:

Spoiler
image.png
Natasha
9 - Comet
Spoiler
Screen Shot 2017-10-29 at 18.11.37.png