Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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.

SUBMIT YOUR IDEA

## Challenge #10: Date Time Calculations

8 - Asteroid

Late to the party but done now :)

Spoiler

7 - Meteor

Solution

8 - Asteroid
Spoiler

7 - Meteor

Attached is my solution for this challenge.

7 - Meteor

It too me a while to realize that the input and output "time now" was not identical. this is my solution i did not know about the MOD function why i did it this way

Spoiler

6 - Meteoroid
Spoiler
Used both the rougher

Hours: DateTimeDiff([Time_Now],[TIMESTAMP],'Hours')-[Days]*24

Minutes: DateTimeDiff([Time_Now],[TIMESTAMP],'Minutes')-([Days]*24+[Hours])*60

And the cleaner
DateTimeDiff([Time_Now],[TIMESTAMP],'Seconds')-DateTimeDiff([Time_Now],[TIMESTAMP],'Minutes')*60

8 - Asteroid
Spoiler
7 - Meteor

Spoiler

7 - Meteor

Hi, it's my solution. Regards

8 - Asteroid

My answer is same till hour but i haven't done nothing wrong in my point of view 🤔

Spoiler