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

Can I fit a quick Alteryx Challenge before my next meeting? Yes, I can!!

Highlighted
8 - Asteroid

Please find the attached solution

Highlighted
7 - Meteor

My solution

Highlighted
 
Highlighted
Alteryx
Alteryx

Completed using the Formula tool and the DateTimeDiff calc

Highlighted
Alteryx Partner

Nice little intro to DateTime formulas.

 

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


Highlighted
7 - Meteor

Hi - Attaching solution here. I did not go the modulo route, but it worked!

Highlighted
8 - Asteroid

My Solution

Highlighted
7 - Meteor

I liked the simplicity (just one tool required), but it took me a while to get my head around the 'TimeDiff' function 

Highlighted
Alteryx Partner