CFLib.org – Common Function Library Project

Description:
Returns True if the date provided in the first argument lies between the two dates in the second and third arguments.

Return Values:
Returns a Boolean.

Example:

<CFOUTPUT>
IS Today IN November of 2001? #IsDateBetween(Now(),"11/1/01","11/30/01")#
</CFOUTPUT>

Parameters:

Full UDF Source:

/**
 * Returns True if the date provided in the first argument lies between the two dates in the second and third arguments.
 * 
 * @param dateObj       CF Date Object you want to test. 
 * @param dateObj1      CF Date Object for the starting date. 
 * @param dateObj2      CF Date Object for the ending date. 
 * @return Returns a Boolean. 
 * @author Bill King (bking@hostworks.com) 
 * @version 1, November 29, 2001 
 */
function IsDateBetween(dateObj, dateCompared1, dateCompared2)
{
 return YesNoFormat((DateCompare(dateObj, dateCompared1) gt -1) AND (DateCompare(dateObj, dateCompared2) lt 1));
}