– Common Function Library Project


Last updated September 6, 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;
blog comments powered by Disqus


Latest Additions

Kevin Cotton added
May 5, 2016

Raymond Camden added
April 25, 2016

Chris Wigginton added
January 18, 2016

Gary Stanton added
November 19, 2015

Sebastiaan Naafs - van Dijk added
November 13, 2015

Created by Raymond Camden / Design by Justin Johnson