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

dsmdavid
11 - Bolide

I think the single tool would work, but I am trying to get my head around iterative macros and regex so...

 

Spoiler
34.pngit-34.png
JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

CHarrison
8 - Asteroid

My solution :) 

asabau
8 - Asteroid

Here it is!

Inactive User
Not applicable
 
kcoulon
8 - Asteroid

I did this a little differently than the provided solution, but it seems to work!

svenk
8 - Asteroid

My Solution!

justynam
8 - Asteroid

My solution :-)

Laurap1228
11 - Bolide

Here is my solution. Short and sweet :)

tcroberts
12 - Quasar

Here's my solution, although perhaps there's been an Alteryx update that has invalidated this challenge, since I feel like I must be missing something:

 

Spoiler
WC34macro.PNG

Initially, when trying to tag the DateTime strings, I had the following regular expression:
[0-][0-9]?/[0-9][0-9]?/\d\d\d\d \d:\d\d
which tagged all rows which had single-digit hours.

However, it turned out that everything worked when I simply passed it through the DateTime tool, and I was able to add the leading 0 by simply passing it back through with a custom DateTime format.