Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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