Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.