Challenge #414: Mastering Date Formats

[olga_strubbe]

This was a good practice in formatting dates.  Thank you, @AYXAcademy!

I like to keep it simple and used a Formula function with 'Contains' clause to solve the challenge - similar to @mmontgomery.  This keeps it down to just using 2 tools :)

[oscar_leeper_wf]

I liked mmontgomery's posting of some more details:

Spoiler

For my solution, I found that FormatDateTime wouldn't take a column as a format variable, so instead, I parsed all date and format components out into their own columns, then used an if statement to extract the year, month and day in an Alteryx friendly format:

[alexnajm]

Too common! 😂

Spoiler

[ARussell34]

Here are the translated dates!

[Powerhouse_21]

Spoiler

 

[TurboToad]

Felt like the solution needed a macro :)

Spoiler

[Qiu]

Without the exception of "29-01-2020,dd.mm.yyyy", it would be just one Text to Column too and one Formula tool with two Formulas. 😁

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

 

 

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow


Formula Tool 1
Date Field = ReplaceChar([Date Field], "/.", "-")

Date Specifier Conversion Table

char	code
yyyy	%y
mm	%m
dd	%d

Formula Tool 2
DateTimeParse([1],[2])

[RolandSchubert]

Spoiler

It only needs one formula tool