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