I would use a date/time field in the database. I would use CreateODBCDateTime(Now())
for date/time stamps. And I would use DateDiff for time comparisons.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 25, 2000 8: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=sts
> 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?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
