Challenge #10: Date Time Calculations

[payam2]

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

[jagdeep_singh85]

Please find the attached solution

[keefeale]

My solution

[wdavis]

Completed using the Formula tool and the DateTimeDiff calc

[Shifty]

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)

[Inactive User]

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

[Vidya26]

My Solution

[gdell]

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