Challenge #34: Date-Time Formatting

[GeneR]

Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback.  The link to the solution for last challenge #33 is HERE.  For this chalenge let’s look at creating a macro from scratch.  I recommend you first solve the problem with tools on the canvas, then cake a macro from the tools.

Use Case:  Our customer has a need to convert date/time strings into a date-time format.

Examples of the different input formats include:  4/8/2015 4:00, 5/10/2015 13:00.  The conversion is automatic when the hours are 2 digits (10-24), but it ignores hours 1-9 (creates NULL values on conversion).

Objective:  Create a macro to effectively convert and preserve the data in a date-time format.

[BenChan]

Thank you for posting this amazing exercise. 

I am new to Alteryx community. Does anyone know how to upload my yxmd and yxmc files onto Alteryx Community?


Here is my smiling-face macro:

Here is what's inside my smiling-face macro:

Spoiler

[MattD]

Here's a solution:

Spoiler

[SeanAdams]

nice quick one.

Solution attached - very similar to the provided solution

[MarqueeCrew]

I think that this is straight-forward (after finding the reverse update).

Cheers,

Mark

[NicoleJohnson]

My solution.... in a single formula!! This might be the first time I've had a one-tool solution!! :)

Spoiler

Formula Tool = DateTimeParse(Left([date_time],FindString([date_time]," "))+" "+PadLeft(Substring([date_time],FindString([date_time]," ")+1,8),5,"0"),"%m/%d/%Y %H:%M:%s")

[estherb47]

My solution. Took a number of tries to get everything right.

[LordNeilLord]

I think the datetime convert maybe my favourite tool...so easy and simple

Spoiler

[nick_ceneviva]

Solution Attached.

[patrick_digan]

Spoiler