I have a string strExpDate and I get the value "
130836384000000000" from ldap query. The active directory field is
accountExpires. I need to convert this to date/time. The result should be
8/9/2015 7:00:00 PM. I tried convert this string to number but the formatting of the
1E+30. I can't use this number value to calculate date. I wanted to use this formula
(strExpDate/(8.64*10^11))-109205 but not sure which action I need to use. Any suggestions?
The following formula in excel gives
8/9/2015 7:00:00 PM