topic Re: Challenge #34: Date-Time Formatting in Weekly Challenges

Challenge #34: Date-Time Formatting

GeneR — Tue, 13 Sep 2022 16:57:49 GMT

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.

Re: Weekly Exercise #34: Macro Development Date-Time Formatting (Advanced)

BenChan — Wed, 27 Jul 2016 02:09:04 GMT

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:

Re: Weekly Exercise #34: Macro Development Date-Time Formatting (Advanced)

MattD — Mon, 01 Aug 2016 15:54:33 GMT

Here's a solution:

Re: Challenge #34: Date-Time Formatting

SeanAdams — Wed, 29 Mar 2017 16:30:39 GMT

nice quick one.

Solution attached - very similar to the provided solution

Re: Challenge #34: Date-Time Formatting

MarqueeCrew — Wed, 05 Apr 2017 21:02:30 GMT

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

Cheers,

Mark

Re: Challenge #34: Date-Time Formatting

NicoleJohnson — Thu, 27 Apr 2017 03:52:36 GMT

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

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")

Re: Challenge #34: Date-Time Formatting

estherb47 — Mon, 01 May 2017 19:40:30 GMT

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

Re: Challenge #34: Date-Time Formatting

LordNeilLord — Wed, 07 Jun 2017 18:51:10 GMT

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

Re: Challenge #34: Date-Time Formatting

nick_ceneviva — Tue, 12 Sep 2017 15:15:00 GMT

Solution Attached.

Re: Challenge #34: Date-Time Formatting

patrick_digan — Tue, 19 Sep 2017 17:09:34 GMT

Re: Challenge #34: Date-Time Formatting

JoshKushner — Fri, 10 Nov 2017 02:24:51 GMT

Love all this practice with Regex. These weekly challenges trained me to regex in my sleep now. (seriously)

Re: Challenge #34: Date-Time Formatting

Natasha — Sun, 12 Nov 2017 15:52:37 GMT

I either don't get this challenge or it is outdated. Anyway here is my solution

1) Currently the date-time converter tool handles both 01 and 1 records of date and time
2) I don't see the reason for creating a macro

Re: Challenge #34: Date-Time Formatting

samN — Sat, 02 Dec 2017 02:16:11 GMT

Macros and regex!? Must be my lucky day

Forgot to attach my Macro the first time

Re: Challenge #34: Date-Time Formatting

ggruccio — Wed, 06 Dec 2017 02:15:31 GMT

Quick and easy macro solution!

Re: Challenge #34: Date-Time Formatting

philipmannering — Tue, 12 Dec 2017 17:55:33 GMT

Tried two solutions. And realised that there's no need to pad when using the datetime format tool. Solution attached.

Re: Challenge #34: Date-Time Formatting

LandonG — Wed, 13 Dec 2017 13:36:13 GMT

Solution attached.

Re: Challenge #34: Date-Time Formatting

jasperlch — Fri, 15 Dec 2017 03:50:09 GMT

Solution attached.

Re: Challenge #34: Date-Time Formatting

msicak — Tue, 26 Dec 2017 00:14:48 GMT

conquered my fear of macros. for now.

Re: Challenge #34: Date-Time Formatting

jamielaird — Tue, 26 Dec 2017 20:00:00 GMT

Here's my solution.

Re: Challenge #34: Date-Time Formatting

Waynemk — Tue, 02 Jan 2018 21:55:06 GMT

here is the macro