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

AMansour
11 - Bolide

Hi 

 

here's my solution 

 

Spoiler
Capture d’écran 2020-04-29 à 21.12.42.png

cheers

Amr

KGS
8 - Asteroid

Hi,

 

My solution attached. 

 

 

Best,

 

G

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

terry10
11 - Bolide

TBH, the automatic conversion worked without the issue described in the challenge. Perhaps the DateTime tool was improved since the challenge was originally posted.

Sylvana
8 - Asteroid

A simple solution:

Spoiler
Sylvana_1-1588854234192.png

 


 

AlexC2
8 - Asteroid

solution attached

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sharing my solution.

 

Using  STRCSPN made this exercise very simple.

 

Spoiler
Challenge_34_Emil_Kos.PNG
cc000072
8 - Asteroid

Here is my solution

Spoiler
WeeklyChallenge_Ryohei_34.JPG
Treyson
13 - Pulsar
13 - Pulsar

In the original download file it says this is week 33. Macros are fun. I remember early on this attaching a dropdown to a macro input blew my mind.

Treyson Marks
Senior Analytics Engineer
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590160370699.png