The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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 #34: Date-Time Formatting

BS_THE_ANALYST
15 - Aurora
15 - Aurora

One tool solution, only using two expressions. I wouldn't suggest against this solution .. 😂

BS_THE_ANALYST_0-1674586197300.png

 

All the best,
BS

LinkedIN

Bulien
kristiadiuisan
Asteroid
Spoiler
Alteryx_challenge_34_KU.png
keynguyen
Asteroid
Spoiler
challenge 34 sol.jpg


Macro: 

Challenge 34 macro.jpg

FinnCharlton
Pulsar
Spoiler
FinnCharlton_0-1675706825049.png

 

Macro spoiler:

Spoiler
AnnaMikhaylova_0-1676613791245.png

 

Solved

putu_w_erata
Asteroid
Spoiler
putu_w_erata_0-1676628215912.png

 

Ben_Connor96
Meteor
Spoiler
Ben_Connor96_0-1677154320410.png

 

Solution above ^ nice macro practice

mark007
Asteroid

Solved.  I've offered up two solutions to the challenge, both which can easily be put in to a macro.

jerviss53
Asteroid

Solution attached

CeliaC_Silje
Asteroid
Spoiler
CeliaC_Silje_0-1677568917660.png

I guess there should be no DateTime Parse tool at the time when this challenge was posted?

So it required a macro to do the thing.