Challenge #10: Date Time Calculations

[Vanousheh]

My solution with only one Preparation.

[Joppa]

Challenge completed using DateTimeDiff tool

[anay_zinje]

Solved this exercise.

have used formula tool to extract day, minutes, hours, seconds from two dates provided.

[Tanbir89S]

I feel like I'm playing games while I'm creating Alteryx workflows.

Solved! Solved! Solved!

Tools to get the solution are - Formula


Used Formulae are - 

Days - DateTimeDiff([TIME_NOW],[TIMESTAMP], 'days')

Hours - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "hours"),24)

Minutes - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "minutes"),60)

Seconds - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "seconds"),60)

[keynguyen]

Spoiler

 

[caltang]

Solved! 

Though cross-checking was one tough one. Thought I was doing something wrong for a solid 10 minutes. 

Spoiler

[lapin_dangelau_24]

my solution

[SarikaFrancis]

[JFarrierMa001]

Spoiler

[LillyVogt95]

The two files being different really messed with my brain but we got there lol!