On 25/03/2011 2:11 AM, Dorioo wrote:
>
> Well, I've found that the code below will give me the first part before the
> period ("40626"). Assuming the second part is the time, I still have to
> figure out the calculation it's using.
>
> <cfdump var="#datediff("d","12/30/1899","{ts '2011-03-24 00:00:00'}")#">.374166700 is a decimal part of a day isn't it? 9am is 3/8 of a day which is .375 -- Yours, Kym Kovan mbcomms.net.au ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
