Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

MarMu
8 - Asteroid

 

Pretty straight forward solution. I probably wouldn't characterize this as an "Advanced" challenge.

I think that a macro might be a bit over the top for this 3 tool solution.

 

Spoiler
challenge_34_start_file_MarMu.png

 

OllieClarke
15 - Aurora
15 - Aurora

Nice one this one:

Spoiler
challenge 34 macro.PNGChallenge 34.PNG
KOBoyle
11 - Bolide

Solution attached. Not knowing the history, like some other I tried using the DateTime Parse tool

JoBen
11 - Bolide

Cheers!

DavidP
17 - Castor
17 - Castor

Here's my solution

dharini
8 - Asteroid

My first macro!

pasccout
8 - Asteroid

Here is my solution

Staal
7 - Meteor

My solution

StevenBetts
8 - Asteroid

Here's my solution :)

 

Spoiler
Challenge 34.jpg
Jim7
8 - Asteroid

Here's my solution, using regex to correct the single digits in the original date/time string.