AnsweredAssumed Answered

Round Up Milliseconds from timestamps in AF-Analysis

Question asked by ken_reiss on Oct 24, 2019

We know of an easy way to round down the milliseconds from a timestamp using the Trunc() function, but what would be the equivalent to round up the milliseconds to the next nearest second?  I've tried the Ceiling() function, but that did not work.

 

I know that we can get the milliseconds using a multi-step approach as documented here: Milliseconds from timestamps in AF-Analysis but I'm hoping for something cleaner and in a single function if possible.  Any ideas?

Outcomes