CFLib.org – Common Function Library Project

Description:
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.

Example:

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

Parameters:

Full UDF Source:

<cfscript>
/**
 * Converts Active Directory 100-Nanosecond time stamps.
 * 
 * @param adTime 	 Time in ActiveDirectory format. (Required)
 * @return Returns a struct. 
 * @author Tariq Ahmed (&#116;&#97;&#114;&#105;&#113;&#64;&#100;&#111;&#112;&#101;&#106;&#97;&#109;&#46;&#99;&#111;&#109;) 
 * @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 );
	retVal.date = Dateformat(retVal.ts,'mm/dd/yyyy');
	retVal.time = Timeformat(retVal.ts,'HH:mm');
	return retVal;
}
</cfscript>