This won't work if difference greater than 59secs, or 2nd seconds less greater than 1st seconds.
-----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 6:26 PM To: CF-Talk Subject: RE: DateDiff weirdness Try making them BOTH createDateTime() values THEN using datediff() on those values. If that doesnt work, try this... <cfset firstdate = 20061129041148 /> <cfset seconddate = dateformat(now(), 'yyyymmdd') & timeformat(now(), 'hhmmss') /> <cfset diff = secondate - firstdate /> ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 6:17 PM To: CF-Talk Subject: DateDiff weirdness I have a date value in this format: yyyymmddhhmmss, for example 20061129041148. What I need to do is calculate the difference in seconds between this date and now(). So I figured I'd use createDateTime() to turn it into a valid date/time object, and then use dateDiff(). However, doing that I get a huge difference returned, like 43529, when there are truly only 5 seconds between the two date/times. Any ideas? ---------------------------------------------------------------------------- -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ============================================================================ == "EMF <idahopower.com>" made the previous annotations. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
