Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALove a good DateTime challenge! Solved this one with one tool! 😀
To other challengers, the Time_Now value in the Output is different than the one in the Input, so your results will not match.
Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-[Days]*24
Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')-([Days]*1440)-([Hours]*60)
Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds')-([Days]*86400)-([Hours]*3600)-([Minutes]*60)
Cheers!
Phil
Here's my solution. This is a beginner challenge, I would not agree for this to be an intermediate.