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
14 - Magnetar

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

BS_THE_ANALYST_0-1674586197300.png

 

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_34_KU.png
keynguyen
8 - Asteroid
Spoiler
challenge 34 sol.jpg


Macro: 

Challenge 34 macro.jpg

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1675706825049.png

 

AnnaMikhaylova
8 - Asteroid

Macro spoiler:

Spoiler
AnnaMikhaylova_0-1676613791245.png

 

Solved

putu_w_erata
8 - Asteroid
Spoiler
putu_w_erata_0-1676628215912.png

 

Ben_Connor96
7 - Meteor
Spoiler
Ben_Connor96_0-1677154320410.png

 

Solution above ^ nice macro practice

mark007
8 - Asteroid

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

jerviss53
8 - Asteroid

Solution attached

CeliaC_Silje
8 - 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.