Store DATETIME() on loggin and logout. Subtract the two and
it returns the difference in seconds (even when days apart).
-myron kirby-
===========================================
>I'm trying to track the amount of time a user is logged in to a specific form. I need to calculate the difference between their form.init(login time) and form.destroy(logoff time) and display it as a character field in a log table. I've been trying by using the Seconds() function, but this only calculates seconds since midnight. Many of my users will be logged in from 9PM one night 'til 4AM the following morning. How can I track this? I'm sure this has been solved long ago, but I can't find it in the documentation.
>
>TIA
>
>--lincoln