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

EricWe
Alteryx
Alteryx
 
Hannah_Lissaman
11 - Bolide

Here's my solution :)

cgoodman
ACE Emeritus
ACE Emeritus

I think the key benefit of doing this as a macro is so you can put a cool picture in for your macro tool.

Spoiler
MacroMacroWorkflowWorkflowb
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Greg_Murray
12 - Quasar

Solution attached

myastarling
11 - Bolide

This was interesting. I originally used the date time parse tool by itself and it converted the dates just fine, despite their being variably one or two characters per date part. Date_time was not in the exact desired format in the output, but I'm assuming the desired field for use would be DateTime_Out. Either way, the macro includes the workflow to produce an exact replica of the desired output as well as the one tool solution.

Johnny_Analytics
8 - Asteroid
Spoiler
Challenge_34_Macro.png
Cosmin_S
8 - Asteroid

Solution attached.

Thank you. 

bnelly1987
8 - Asteroid
Spoiler
Solution-Challenge 034.PNG
FRANCK_ROUQUETTE
8 - Asteroid
here is my solution with iterative macro - good exercise to understand iterative macro - thanks for the exercises
FRANCK_ROUQUETTE
8 - Asteroid
here is my solution with iterative macro - good exercise to understand iterative macro - thanks for the exercise - with the correct file (package including macro)