UDFs: containsLeapYear()

containsLeapYear()

Function that determines if a given date range contains a leap year.

<CFSCRIPT>
/**
 * Function that determines if a given date range contains a leap year.
 * 
 * @param startDate  Initial date. (Required)
 * @param endDate    Ending date.  (Required)
 * @return Returns a boolean.
 * @author Mosh Teitelbaum
 * @version 1, May 26, 2003
 */
function containsLeapYear(startDate, endDate) {
  // Build offsets
  var StartDateYearOffset = DateAdd("yyyy", 1, startDate);
  var StartDateYearOffsetInDays = DateDiff("d", startDate, StartDateYearOffset);
  var EndDateYearOffset = DateAdd("yyyy", 1, Trim(endDate));
  var EndDateYearOffsetInDays = DateDiff("d", endDate, EndDateYearOffset);

  // Return result
  return IIf(StartDateYearOffsetInDays - EndDateYearOffsetInDays GT 0, DE("true"), DE("false"));
}
</CFSCRIPT>

This UDF is also available from cflib.org at http://www.cflib.org/udf/containsLeapYear.