Jim,
>Datetimes are accurate to the millisecond
>but we can only access the seconds.
True, but I am not getting the times, I am creating them
issuing a= {^2002-01-01 15:22:00}. So even if there are
milliseconds in the "background" they should be 0 or 50 or
whatever, but at least the same amount of milliseconds each
time You "create" a time. just like in dtot(
) where
You're always getting midnight.
I don't think it really has to do with the m'secs (this
was my first thought too. That's why I played with "written"
dates). Cetin is probably more right (see Message#655097 in this
thread).
>Better than round() in this situation is ceiling() as in;
>lnSecs = CEILING(DT1 - DT2)
Yes, that's better. I guess round(, 0) is pretty good
as what I found is veeeeeeery close to 1. But under some
weird calculations You might end up with a swallowed second.
But as what I get is always a bit smaller than 1 when I really
whant 1, ceiling() is probably the better choice.
Regards from Berlin (25°C / Thunderstorms)
Frank