– Common Function Library Project


Last updated September 07, 2006


Tariq Ahmed

Version: 1 | Requires: CF6 | Library: DateLib

Time in Active Directory is stored in a 64 bit integer that keeps track of the number of 100-Nanosecond intervals which have passed since January 1, 1601 (not to be confused with EPOCH). The 64 bit value uses 2 32bit parts to store the time. This function simply takes that number, and converts it for easy use. Algorithm adapted from a House of Fusion posting from David Strong. Returns a structure with the following elements: date: mm/dd/yyyy formatted date. time: HH:mm formatted date. ts: Raw timestamp.

Return Values:
Returns a struct.


<cfset stADDateTime = convertActiveDirectoryTime("127944393687163952")>
The Date is #stADDateTime.Date# and the time is #stADDateTime.Time#. 
Or freestyle format of: #DateFormat(stADDateTime.ts,"MMDDYYYY")# #TimeFormat(stADDateTime.ts,"hh:mmtt")#


Name Description Required
adTime Time in ActiveDirectory format. Yes

Full UDF Source:

 * Converts Active Directory 100-Nanosecond time stamps.
 * @param adTime      Time in ActiveDirectory format. (Required)
 * @return Returns a struct. 
 * @author Tariq Ahmed ( 
 * @version 1, September 6, 2006 
function convertActiveDirectoryTime(adTime) {
    var retVal = structNew();
    var tempTime = arguments.adTime / (60*10000000);
    retVal.ts = DateAdd('n',tempTime,'1/1/1601');
    retVal.ts = DateConvert("utc2Local", retVal.ts ); = Dateformat(retVal.ts,'mm/dd/yyyy');
    retVal.time = Timeformat(retVal.ts,'HH:mm');
    return retVal;


Latest Additions

Raymond Camden added
November 04, 2017

Leigh added
May 11, 2016

Raymond Camden added
May 10, 2016

Kevin Cotton added
May 05, 2016

Raymond Camden added
April 25, 2016

Created by Raymond Camden / Design by Justin Johnson