Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #34: Date-Time Formatting

dbAlfa
8 - Asteroid

Attached my solution, my macro.

jennifer_owens
8 - Asteroid

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

rachel_lynch
Alteryx
Alteryx
Spoiler
Date-Time Formatting.png

Rachel Lynch
e_d_g
7 - Meteor

solution

RodrigoAzul2023
5 - Atom

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 

 

 

Regex.PNG

 

Formula.PNG

Towers
11 - Bolide

fun one!,

Spoiler
Screenshot 2023-07-13 120448.png

mithily
8 - Asteroid
Spoiler
a simple macro need to know the date specifiers
lwolfie
10 - Fireball

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

H_a_n_g_C_h_e_n__x3
8 - Asteroid

A breath of fresh air

GabrielaTudor
8 - Asteroid
Spoiler
Challenge34.jpg