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

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".