Wow, David, that works. Thank you. Wonder why they chose 1/1/1601 as the starting point.
Johnny > 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:242355 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54