FWIW, if I get rid of the INT() I then get the expected 11 being returned. I got this code from a similar function in KiloFox, any ideas why the INT is necessary? My elapsed time will always be a whole number of seconds (or at least should be as I get it from subtracting a date time field from another date time field.
>Hi,
>
>I've got a function that displays seconds in the format HH:MM:SS.
>
>In calculating the seconds part of the string, I do this:
>
>
>INT(m.tnElapsedSeconds % 60)
>
>
>When m.tnElapsedSeconds = 71 I get 10 being returned, but only when the function is called in a report!
>
>Anybody have any idea what could be causing this?