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

Suzu
9 - Comet

Here is my solution.

vsoni
Alteryx
Alteryx

My solution attached! 

KeithTroutt
8 - Asteroid

couldn't this been accomplished with just the Datetime tool? 

Spoiler
Challenge 34 Spoiler.PNG
rfergus
8 - Asteroid

Seems like it was too easy with the right tools and formulas.

 

Spoiler
image.png
RolandSchubert
16 - Nebula
16 - Nebula

My solution

FeedMeData
8 - Asteroid

I only needed the DateTime tool to get the output. I'm guessing the DateTime tool was not as capable back in 2016 as it is now

RichoBsJ
11 - Bolide

Hi! Here my solution :)

hanykowska
11 - Bolide

I thought building a macro would be more difficult than it is once you have the flow worked out...

cplewis90
13 - Pulsar
13 - Pulsar

This one was pretty simple as they have seemed to have fixed the DateTime tool to incorporate this issue. I solved it with just that tool, but also going through the process of adding all the extra 0s.

Spoiler
Challenge 34.PNG
JoshuaGostick
11 - Bolide

Pleased to have done that in one formula tool!

 

Spoiler
challenge_34_macro.PNG
Spoiler