UUIDGetTimestamp ( theID )

Extracts the creation timestamp from a UUID created by the UUIDNew function

Average rating: 4.1 (40 votes) Log in to vote

Jeremy Bante

https://github.com/jbante/

Sample input:

UUIDGetTimestamp ( "1-2-063440624691-3530000-04098-000102857824654" )

Sample output:

5/10/2011 11:44:51.353 AM

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/**
 * ======================================
 * UUIDGetTimestamp ( theID )
 *		https://github.com/jbante/FileMaker-Techniques/blob/master/CustomFunctions/UUID/UUIDGetTimestamp.fmfn
 *
 * PURPOSE:
 *		Extracts the creation timestamp from a numeric UUID created by this
 *		family of UUID functions. The returned value can be converted to a more
 *		conventional format with the GetAsTimestamp function.
 *
 * RETURNS:
 *		A number representing the number of seconds since 0001-01-01 00:00:00
 *		when the UUID passed as a parameter to the function was created. Returns
 *		Null ("") if the UUID is in a format that does not contain a retrievable
 *		timestamp.
 *
 * PARAMETERS:
 *		theID: The UUID to extract a timestamp from.
 *
 * DEPENDENCIES: none
 *
 * HISTORY:
 *		MODIFIED on 2011-02-02 by Jeremy Bante to use a format with a bijective
 *		relationship with the RFC 4122 format.
 *		MODIFIED on 2010-11-22 by Jeremy Bante to extract timestamps from the
 *		updated output format for UUIDNew.
 *		CREATED on 2010-09-12 by Jeremy Bante <http://scr.im/jbante>.
 *		INSPIRED by UUID functions created by Ray Cologon.
 *
 * REFERENCES:
 *		Key values Best Practice: http://filemakerstandards.org/pages/viewpage.action?pageId=557138
 *		Ray Cologon's uID functions: http://www.nightwing.com.au/FileMaker/demos9/demo910.html
 *		UUID functions: https://github.com/jbante/FileMaker-Techniques/tree/master/CustomFunctions/UUID
 * ======================================
 */

Let( [
	~idAsNumber = GetAsNumber ( theID ) ;
	~length = Length ( ~idAsNumber ) ;
	~version = Left ( ~idAsNumber ; ~length - 40 )
] ;
	If ( ~version < 3 ;
		GetAsTimestamp ( GetAsNumber (
			Middle ( ~idAsNumber ; ~length - 38 ; 12 )	// seconds
			& "."
			& Middle ( ~idAsNumber ; ~length - 26 ; 7 )	// sub-seconds
		) )

		/* Else, UUID does not have a timestamp; return Null */
	)
)

Extracts the creation timestamp from a numeric UUID created by this family of UUID functions. The returned value can be converted to a more conventional format with the GetAsTimestamp function.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

UUIDGetTimestamp ( theID )

Comments

Support this website.

Support this website.