Challenge #10: Date Time Calculations

[Sylvana]

My solution

[VenkateshJeyaraj]

The trickiest part to me is finding the difference then using the mod function to get the hours,mins,secs: well, i used the below formula to achieve the result.

Mod(tonumber(DateTimeDiff([Time_Now],[TIMESTAMP],'hours')),24)

[Lucatelli]

Please find attached my solution.

[cody_rush]

Spoiler

[FredNajjar]

Spoiler

[Ben_Jeffreys]

My submission

[Chiaroscuro]

Hi! I'm here again to share my solution.

This challenge is quite challenging though if you base on the data that were in the start file and solution file.

I was tricked! I thought my solution was wrong because of the 41 seconds interval with the given solution.

When I checked again and again, the given values were not the same. Haha!

So... yep, my solution is correct. I almost doubted myself.

Here's a preview of my solution. I only used the Formula Tool in generating the solution.

Spoiler

Have a nice day! 🙂

[jarrod]

starting to learn that referencing columns in Python Dataframes is as simple as df['column_name'] (case sensitive!!!) that's a nice part about alteryx is that it isn't natively case sensitive. 

Spoiler

#SnakingMyWayThruChallenges

[Milanz]

done 😉

timestamp difference added to start dates

[deepaprash]

Solved. Learnt modulo 🙂