alteryx Community

# 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.

## Challenge #10: Date Time Calculations

6 - Meteoroid

solution:

8 - Asteroid

My solution below (two similar ways, but the seconds feels more elegant):

Spoiler
Both solutions use the DateTimeDiff() function, but the first uses the difference in seconds then works backwards from the number of days to the number of seconds, thereby requiring increasingly long formulae for each subsequent field, where as the second solution uses the difference in days, hours, minutes, seconds and applies the Mod() function to get the remainder for hours-to-seconds fields
6 - Meteoroid
Spoiler
8 - Asteroid
Spoiler

9 - Comet

I added 41 seconds to my input so that i could validate it matched the output :)

Spoiler
7 - Meteor
Spoiler

7 - Meteor

Thank you!

8 - Asteroid

Challenge #10: Date Time Calculations

7 - Meteor

Solution

7 - Meteor
Spoiler