Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 :)

cgoodman3
14 - Magnetar
14 - Magnetar

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)