CFLib.org – Common Function Library Project

convertActiveDirectoryTime(adTime)

Last updated September 6, 2006

author

Tariq Ahmed

Version: 1 | Requires: CF6 | Library: DateLib

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:

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 (tariq@dopejam.com) 
 * @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;
}
blog comments powered by Disqus

Search CFLib.org


Latest Additions

Kevin Cotton added
date2ExcelDate
May 5, 2016

Raymond Camden added
CapFirst
April 25, 2016

Chris Wigginton added
loremIpsum
January 18, 2016

Gary Stanton added
calculateArrival...
November 19, 2015

Sebastiaan Naafs - van Dijk added
getDaysInQuarter
November 13, 2015

Created by Raymond Camden / Design by Justin Johnson