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

BSilverblatt
8 - Asteroid

Thanks for the challenge! This is my solution.

DanJ3
8 - Asteroid
 
wdavis
Alteryx Alumni (Retired)

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 Alumni (Retired)

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