We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #34: Date-Time Formatting

ahsanaali
8 - Asteroid

ahsanaali_0-1664733425402.png

 

MilindG
11 - Bolide
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
6 - Meteoroid

solution

stephenmoyse
5 - Atom
Spoiler
stephenmoyse_0-1669114458476.png