Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.