I don't think this is a Spectra specific date, but it may be an atomic date (sorry....not up to speed on all the odd formats).
So the first thing you need to sort out is the type of date format that number represents. Then it should be easy to find the function you need to take a normal date and produce one of those dates (either already available in CF or perhaps via UDF or other easy bolt-ons). Wow....so some Spectra code actually made it into production before it collapsed in on itself under its own weight huh ;-) Cheers On Thu, 2011-03-24 at 10:06 -0400, Gabriel Ortiz 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:343249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
