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

Inactive User
Not applicable
 
CM17
6 - Meteoroid

Here's my solutionHere's my solution

jbranaum
8 - Asteroid

My Solution.

archietao
8 - Asteroid

My solution here:

 

Am I the only one who feel this description is a bit confusing? 

 

"The conversion is automatic when the hours are 2 digits (10-24), but it ignores hours 1-9 (creates NULL values on conversion)."

 

Otherwise, only one single date/time parse tool can complete the conversion. 

 

 

jssandom
8 - Asteroid

I feel like this must have been harder in 2016! :)

JamesMA
Alteryx Alumni (Retired)

First macro built independently!

Karam
8 - Asteroid

Solution attached.

 

Spoiler
challenge 34.PNG
KaneG
Alteryx Alumni (Retired)

I just broke the date apart, padded it and then put it back together...

Spoiler
Inside of the Macro
Challenge34.png
CapriceW
8 - Asteroid

Here goes!

ipeng
8 - Asteroid

Solution Attached!