Ask Ben: Displaying And Formatting The Difference Between Two Dates

code-1.cfm

<!--- Get a start date for our comparison. --->
<cfset dtFrom = ParseDateTime( "01/01/2008 12:00:00 AM" ) />

<!--- Get the current date. --->
<cfset dtTo = Now() />

<!---
	Get the difference between these two dates. Using
	ColdFusion Date Math will give us the numeric version
	of the timespan that represents the difference between
	these two dates... this timespan is represented in the
	number of days between the two dates.
--->
<cfset dtDiff = (dtTo - dtFrom) />


<!---
	Now that we have the difference between the two dates, we
	simply need to format that date/time span using ColdFusion's
	built-in formatting functions.
--->
#DateDiff( "yyyy", "12/30/1899", dtDiff )# Years,
#DateFormat( dtDiff, "m" )# Months,
#DateFormat( dtDiff, "d" )# Days,
#TimeFormat( dtDiff, "h" )# Hours,
#TimeFormat( dtDiff, "m" )# Minutes,
#TimeFormat( dtDiff, "s" )# Seconds