Search

Close

Start Free Trial

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

Here is my solution!

Date-Time Formatting.PNG

Challenge #34, done.

Cheers,

This particular macro is not needed anymore with changes to the Date Time tool, but it is good practice for the advanced exam.

Macro for Challenge 34.GIF

Here's my solution to challenge 34.
I'm guessing this is an outdated challenge considering that the DateTime tool seems to work perfectly.

I've gone with the spirit of the challenge and made a Macro that doesn't use the DateTime tool.

Maybe this tool was fixed since the challenge was released?

My solution:

A macro isn't necessary, as it can be completed using only the datetime tool

My solution both without and with a macro.

My approach was nearly identical to the post solution, but I did not realize we could use multiple delimiters in the text to column, nor did I know about the pad function. So bonus that I picked up 2 new things with this exercise.