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

BSilverblatt
8 - Asteroid

Thanks for the challenge! This is my solution.

DanJ3
8 - Asteroid
 
wdavis
Alteryx
Alteryx

I noticed it was just the Hours field that needed to be padded, so actually did this without building a macro and got the same result

sgrabish1
8 - Asteroid

Done!

ArnavS
Alteryx
Alteryx

May have oversimplified the task

RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_34_RODO_Solution.pngchallenge_34_RODO_Macro_Solution.png
MichaelSu
Alteryx Alumni (Retired)
 
ZenonH
8 - Asteroid

I felt like making a macro with only one formula tool inside it wouldn't be very productive, so I took the chance to make a detailed output, and a simple output. 

Spoiler
ZHSOL.png

 

justindavis
10 - Fireball
 
kmcdaniel
8 - Asteroid

 

Spoiler
This one seems so simple that I'm wondering if I missed the point of the exercise.... the desired conversion can be accomplished with a single date time tool which takes a custom input of "MM/dd/yyyy hh:mm".