Hello again, I am not sure to see how to apply this function. At first, I thought I did. Well, I see how it can work for one DateTime value, but I am evaluating the DateDiff between the current time and time elapsed. How do I apply your function to show something like:
Current Output: Assigned Date: 30-Jan-02 08:55 AM (form variable) Current Date: 30-Jan-02 02:23 PM (current ODBCDateTime) Difference of: 5 hrs, 328 min (5 hrs, 28 min) Obviously the 328 minutes is not correct, should say 28 min. Just need a little more guidance. Thanks. -----Original Message----- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 10:37 AM To: James Taavon Subject: RE: Proper output of elasped DateTime value I attached a UDF that formats in h:m:s. that will do the trick. I posted it on cflib, but it wasn't validated yet. If you have the time in minutes, you can call it like #hmsformat(mytime,"m","HH:MM")# to display it in hours and minutes. Pascal Peters Certified ColdFusion (5.0) Advanced Developer Certified Web Developer Macromedia Certified Instructor LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: woensdag 30 januari 2002 15:28 To: CF-Talk Subject: Proper output of elasped DateTime value I have got a piece of code that calculates the current DateTime from a DateTime in the past. I want to display the elapsed total in both hours and minutes. When the value goes above 1 hour it displays 1 hr, 60 min instead of 1 hr, 0 min. How do I get it to correctly show that? Current code: #Abs(DateDiff("h", get_date.sdate1, CreateODBCDateTime(Now())))# hrs, #Abs(DateDiff("n", get_date.sdate1, CreateODBCDateTime(Now())))# min James ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
