if you're using SQL server, there's an SQL function called DateDiff. it
will calculate the difference of two date/time fields in the DB.
there's also a CF function called DateDiff. it will calculate the
difference of two date/time formatted strings (so you don't REALLY have to
use datetime if you don't want). however, it's recommended, as the DB can
do a lot of that work for you.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
