In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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 #34: Date-Time Formatting

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1631539090556.png

 

Ukashi
8 - Asteroid

It looks that Alteryx advanced over the years and DateTime Parse tool works better and solve all issues in one go.

 

I 've build macro processing input in two ways - one with Date Time Parse and the other way in a more "traditional way"

 

Below my macro solution:

 

Spoiler
Ukashi_0-1632392890689.png

 

Thank you for this fun challenge 🙂

suyash0807
7 - Meteor

Quite Straightforward.

MUHAMMED_NABEEL_P
8 - Asteroid

Done just using a formula tool and Date time parse function

TheOC
16 - Nebula
16 - Nebula

Nice little challenge!

Spoiler
A couple date time tools do the trick!
TheOC_1-1633708875032.png



Cheers,
TheOC
Connect with me:
LinkedIn Bulien
binay2448
11 - Bolide

Find my solution attached...

tommasoBicocchi
7 - Meteor

First solution as a Alteryx user..

nikastar
6 - Meteoroid

Great Challenge!

Spoiler
Screenshot 2021-10-29 173513.png
leozhang2work
10 - Fireball

 

Spoiler
34.png

 

 

PatForData
8 - Asteroid
Spoiler
PatForData_0-1636560929276.png