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:343244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
