Stefan,

I see what you are doing now.

Maybe you can simplify things if you haven't already got everything working.

use datetime alone to measure your elapsed time. Use seconds() to control your much finer subsecond needs. If you use are subtracting seconds() values to determine if it's time to do something, you only have to boundary condition the one instant that the value goes negative, midnight rollover, if the delta is negative just add 86400 to it and it'll put it into the positive value domain. You could wrap all this behavior up in a class that handled the details.

>SECONDS() is perfect for the update interval job but without the help of DATETIME() there is a hard limit of 24 hours with regard to measuring elapsed process time (for benchmarking). Of course, mixing in DATETIME() makes the code more complex.