Try DateDiff(datepart, login_timestamp, logout_timestamp). Make sure you
test for the 2 variables existence first, and be sure to convert them to
ODBC DATETIMES first, too.
~Simon
-----Original Message-----
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 11:42 AM
To: CF-Talk
Subject: Hmm..Calculate Elapsed Time
I'm timestamping logins and logouts, I want to be able to calculate the
time elapsed between the two. My question is, what format should I be
writing these timestamps in, and I'm hoping that there's a function I can
use that is smart enough to just subtract time values....? Thoughts?
Willy
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
