Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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