Challenge #34: Date-Time Formatting

[fluteman]

You essentially have to use text to columns breaking the string into year, month, day, hours and minutes and re-combining. You couldn't just create the datetime; you had to create the date first using a YYYY-MM-DD string and then datetimeadd hours and minutes.

[Archie_bos]

here is my solution

[Ginu_Sunny]

My solution

[CoG]

Spoiler

[ds_tomalexsmith]

Spoiler

 

[RasmusFormo]

Spoiler

[Rob-Silk]

My solution below:

Spoiler

[putu_w_erata]

Spoiler

 

[jeremy-appleyard]

Hi All, 

This is my first post and question, was a macro actually needed ?

In my solution I appear to have achieved the same output results with and without a macros simply using the datetime parse tool.

Is it correct or am I missing something ???? 

[Kristina_Sem]

Spoiler