Remember the EPOCH times for Unix and Windows are different.
Try this, read the comments I have included for you:
<!---
Problem: LDAP date is returned as NANOSECONDS and if you try to write a
function to parse it CFMX returns an error saying the number is too big to fit
in integer scope.
So you have to parse it manually.
--->
<!--- ******** this is the date value from LDAP ********* --->
<CFPARAM name="variables.lastLogon" default="127937470871482500" />
<cfscript>
// parse value into minutes
variables.calcLastLogon = variables.lastlogon / (60*10000000);
//add minutes from WINDOWS EPOCH TIME
variables.finalResult.ts = DateAdd('n',variables.calcLastLogon,'1/1/1601');
variables.finalResult.date = Dateformat(variables.finalResult.ts,'dddd, mmmm
dd, yyyy');
variables.finalResult.time = Timeformat(variables.finalResult.ts,'h:mm tt');
//some basic output
writeoutput('the last logon date was on ' & variables.finalResult.date &' at '
& variables.finalResult.time);
</cfscript>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242340
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
