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'}")#">
- Gabriel
On Thu, Mar 24, 2011 at 10:06 AM, Gabriel Ortiz <[email protected]> wrote:
>
> Working with some legacy spectra data and I'm trying to do a sql search
> based on the spectra date.
>
> A. If I run the code below, I get "03/24/2011 08:58:48 AM"
>
> <cfset spectraData = "40626.374166700">
> <cfdump var="#dateFormat(spectraData,"MM/DD/YYYY")#">
> <cfdump var="#timeFormat(spectraData,"HH:MM:SS TT")#">
>
> B. How do I do this in reverse? In other words, how do I start with
> "03/24/2011 08:58:48 AM" (or some form of it) and get "40626.374166700"?
>
> Thank you,
> Gabriel
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:343245
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
