Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAChallenge completed using DateTimeDiff tool
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)
Solved!
Though cross-checking was one tough one. Thought I was doing something wrong for a solid 10 minutes.