community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #10: Date Time Calculations

Asteroid

Using Datetimediff with mod in one formula tool to define formulas for days, hours,minutes and seconds

Alteryx
Alteryx

My solution:

Highlighted
Alteryx Partner

The quickest challenge I've done so far!

Preview of the workflow:

Spoiler
workflow.PNG
Spoiler
Using a simple formula tool with modulo gives similar results to the given output (since we have different TIME_NOW)
Meteor

solution attached.

Asteroid

my solution

Alteryx
Alteryx
Spoiler
Challenge10.png
Meteor
Spoiler
SpoilerSol10.JPG
Alteryx
Alteryx

My solution attached! 

Alteryx Certified Partner

My solution

Asteroid

One tool solution (the others are to validate the one tool matches Output).