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

Hi,

 

Attaching the solution. Formula used is Datetimediff.

 

Best,

 

G

 

 

Highlighted
8 - Asteroid

Solution attached

Highlighted
7 - Meteor

Finished this challenge with only one Tool. Kinda similar ideas to some people but I guess the calculation is a bit different. 

 

Highlighted
8 - Asteroid
Spoiler
Junya_Wang_0-1588380736812.png

 

just realize that the datetimenow made the answers different haha

Highlighted

Didn't use the MOD function, but long hand version of the same approach. 

Highlighted
Alteryx Certified Partner

I did it a little differently than everyone else (and the outputs don't exactly match because of the known error), but it works like a charm!

Highlighted
8 - Asteroid

My solution. 

Highlighted
Alteryx
Alteryx

Solution Posted

Highlighted
Alteryx
Alteryx

See attached.

Highlighted
7 - Meteor

Used DATETIMEDIFF & MOD. Boom!