In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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

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
10 - Fireball
Spoiler
Screen Shot 2017-10-29 at 18.11.37.png