In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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

MichelleL
Alteryx
Alteryx

2 solutions:

1. Using formula tool

2. Using DateTime parse tool

 

RashedDS
8 - Asteroid

My solution

 

duartepimentel
8 - Asteroid

Solution attached

SimonEvans
8 - Asteroid
Spoiler
Spoiler
Weekly Challenge 34 (1).PNGWeekly Challenge 34 (2).PNG
Elias_Nordlinder
11 - Bolide

Hmmmmmm

Spoiler
Looks like the input file have changed I guess.

1-tool, 1-formula tool macro seems not that effective 😉

Elias_Nordlinder_0-1628848738897.png

 

DanTh
Alteryx Alumni (Retired)
Spoiler
Pretty simple to build out the workflow and then move it into a Macro.
Dan_0-1628849966539.png

@Elias_Nordlinder  - maybe the %H:%M didn't work previously? Your solution is definitely most straightforward!

5/5

MatthewBr
Alteryx Alumni (Retired)

Got creative with the icon in my macro 😂

Kevin_VANCAPPEL
10 - Fireball

Hello,

 

  here is my proposal.

 

  Regards,

  Kévin V.

ARussell34
8 - Asteroid

First posted Macro!

OnionKnight
8 - Asteroid
Spoiler