Challenge #10: Date Time Calculations

[Amarendra]

Solution attached. Used the MOD function as mentioned in the help guide. 

[jdunkerley79]

Lots of formulae :)

[data_rachel]

Spoiler

Pretty standard:

Days = DateTimeDiff([Time_Now],[TIMESTAMP],"days")
Hours = DateTimeDiff([Time_Now],[TIMESTAMP],"hours")-DateTimeDiff([Time_Now],[TIMESTAMP],"days")*24
Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")
-(DateTimeDiff([Time_Now],[TIMESTAMP],"hours")*60)
Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],"seconds")-DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")*60

I noticed that the final output were all output with Byte as the type, so I made that change in my formula tool as well. Resulted in no problems with decimal places.

[JoshKushner]

I'll be honest, I did this problem two different ways and got the same result. Neither of which matched the expected output. Could anyone please take a looks and let me know where I went wrong?

[SeanAdams]

Hey @JoshKushner

The issue is that the solution has a different DateTimeNow stamp in the input vs. the output, so they will never match.   @alex was the first to point this out I believe, so credit is his.

Josh- send me a PM with your personal e-mail, and I'll send you a few pieces that will help you with this kind of question in the future.

[dominiklz]

Spoiler

[dsmdavid]

Good Mod :-)

[samN]

Pretty sure there is a difference between the time nows on the input and output

[Waynemk]

and another

[ggruccio]

Made me think a bit, but got it!