Weekly Challenge

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

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

Submit Feedback
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.

Challenge #10: Date Time Calculations

Highlighted
8 - Asteroid

For some reason this one really threw me for a loop.  Nonetheless I still got a solution finally.

Highlighted
Alteryx Partner
Spoiler
Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days') Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([Days]*24)  Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes') -                 (DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60) Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds') -                  (DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')*60)Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days') Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([Days]*24) Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes') - (DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60) Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds') - (DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')*60)

 

Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([Days]*24)
Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes') -
(DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60)
Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds') -
(DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')*60)

Highlighted
8 - Asteroid

Nice.

Spoiler
ch10.PNGch10_1.PNG
Highlighted
Alteryx Partner

Here's my solution for this challenge. I did update the task input data to be the same as the output data.

Spoiler
Challenge 10.jpg
Highlighted
6 - Meteoroid

This is the shortest method I could think of. Will appreciate if someone could comment on this to tell me if I was right or wrong.

Highlighted
8 - Asteroid
Spoiler
greggrimmer_0-1603293711093.png

 

Highlighted
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-22 à 15.13.38.png
Highlighted
8 - Asteroid

Nice one, Thanks

Spoiler
Screenshot_1.jpg

 

Highlighted
8 - Asteroid
Spoiler
Please see my solution below. 
Highlighted
Alteryx Partner

I went for separate formula tools for each step

Spoiler
MikeLR_0-1604936598992.png