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

7 - Meteor

Think the result output file data is not as accurate but great support from the community. Use the formula tool as well to calculate.

Alteryx

Here is my solution:

Spoiler

8 - Asteroid

Thanks Alex for the heads up.  Couldn't figure out why my times were off.  Checked and it's 41 seconds different for each.

6 - Meteoroid
Spoiler
Days - DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours - DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-DateTimeDiff([Time_Now],[TIMESTAMP],'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
8 - Asteroid

Hello gents,

Cool exercice, thx

8 - Asteroid

Here's my solution...

7 - Meteor

Here is my solution.

8 - Asteroid

Challenge #49

Spoiler

8 - Asteroid

Threw me for a moment that the Time_now in the input is not the same as the one in the sample solution. Guess if I had read the thread first - but would that be cheating?

Spoiler

7 - Meteor
Spoiler
First (and probably last) one with a single tool.