Challenge #34: Date-Time Formatting

[dbAlfa]

Attached my solution, my macro.

[jennifer_owens]

Had some fun and built three different Macros using different approaches to get the formatting (0 padding) correct!

[rachel_lynch]

Spoiler

 

[e_d_g]

solution

[RodrigoAzul2023]

Used the RegEx in Parse mode to break down the String in Month, Day, Year, Hour and Minute and the a formula tool with a ToDateTime formula to convert a  concatenation in the correct format and done. Used my old trick of puting leading zeros that I use since Excel 97 (eg. Right("0000"+Day,2) LOL 

[Towers]

fun one!,

Spoiler

 

[mithily]

Spoiler

a simple macro need to know the date specifiers

[lwolfie]

This may have been harder before the date-time tool was created.

[H_a_n_g_C_h_e_n__x3]

A breath of fresh air

[GabrielaTudor]

Spoiler