I cannot say I know anything about it. But a quick google suggests there there is a .net function that might be of use: DateTime.FromFileTime
Haha. I should have known the time master would have something in his arsenal
cfsearching... ya.. I could just do an exec vb script inside the cf code.. yeah.. uh.. ... actually , that was what I found when I was out looking around.. MS has built in functions for doing the conversion.. but its not a CF solution.
PaulH - you've got a lot of good stuff there
I eventually found my answer on a unix forum (after 4 hours of searching and digging thru all the crap) .. and here is the CF solution:
<cffunction name="fileTimeConvert" access="public" output="false">
<cfargument name="timeString" required="true" type="Numeric">
<cfset var result = ''>
<!--- remove last 7 digits: --->
<cfset var myTempTime = Left(arguments.timeString,11)>
<!--- subtract 11644473600, which is seconds from 1601 to 1970 I think --->
<cfset myTempTime = myTempTime -11644473600 >
<!--- myTempTime is now UNIX epoch time, and do dateAdd: --->
<cfset result = DateAdd("s", myTempTime, "January 1 1970 00:00:00")><cfreturn result></cffunction>
I was thinking if it was some weird MS specific time, and all else failed, you could always call a .net library from CF. But obviously I did not look into it that deeply Glad you found a simpler solution.
actually, I think it is a weird ms-specific thing ... they have a built-in function in VB and C/+ to do the conversions, and I had to dig a long time to figure out what it was. CF was blowing up because it couldn't handle 64-bit integers when I was just trying to do simple math on the values.
>> handle 64-bit integers
True. There is the 32-bit limitation.
actually, I think it is a weird ms-specific thing ... they
have a built-in function in VB and C/+ to do the
conversions, and I had to dig a long time to figure out what
Yeah, it does seem like an ms-specific thing. But by "weird" I was thinking really twisted, complex stuff like the old Office format. Stuff only masochistic people (like the developers at POI) could ever stick with long enough to figure out