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!