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

ahsanaali
11 - Bolide

ahsanaali_0-1664733425402.png

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1665163128301.png

 

OzlemSigbeku
8 - Asteroid

OzlemSigbeku_0-1666278676974.pngThe Macro:

 

Kinga
8 - Asteroid

hi,

 

Please find my solution below:

 

Spoiler
I suspect that this challenge was announce before some upgrade on standard Date-time Tool, because it is possible to do in just by this one. However for training purpose I've added macro solution without Date-Time tool :)
Kinga_0-1666768533085.png
Kinga_1-1666768576256.png

 


 

AndrewHoData
8 - Asteroid

Tested the macro by adding another date. It works!

 

Spoiler
AndrewHoData_0-1667120111977.png 

And the macro workflow below:
AndrewHoData_1-1667120132982.png

 

 

 

 

KrishnaChithrathil
11 - Bolide
Spoiler
KrishnaChithrathil_0-1667904321152.png

 

geoff_zath
Alteryx
Alteryx
Spoiler
Spoiler
geoff_zath_0-1667954785092.png

 

DenisZ
11 - Bolide

Here is my macro

 

Spoiler
DenisZ_0-1667991123034.png

 

Yalini_sk
7 - Meteor

solution

stephenmoyse
5 - Atom
Spoiler
stephenmoyse_0-1669114458476.png