Don't forget - Spectra is just CFML. You should be able to find the function that is doing the conversion.
On Thu, Mar 24, 2011 at 10:19 AM, Kym Kovan <[email protected]> wrote: > > 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:343247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
