CFLib.org – Common Function Library Project

Description:
A function which returns a End Of Day TimeStamp. For example, 1/1/2000 returns {ts '2000-01-01 23:59:59'}. Useful for SQL queries when users search by date ranges and you need to include all values by the end of a certain date period.

Return Values:
Returns a timestamp.

Example:

<cfset EOD = getEndOfDayTS("1/1/2000")>
<cfoutput>#EOD#</cfoutput>

Parameters:

Full UDF Source:

/**
 * A function which returns a End Of Day TimeStamp. For example, 1/1/2000 returns {ts '2000-01-01 23:59:59'}.
 * 
 * @param date      Date to use. (Required)
 * @return Returns a timestamp. 
 * @author Sami Hoda (samihoda@gmail.com) 
 * @version 1, January 30, 2006 
 */
function getEndOfDayTS(date) {
    var vDate = date;
    vDate = dateFormat(vDate, 'MM/DD/YYYY');
    vDate = DateAdd("h",23,vDate);
    vDate = DateAdd("n",59,vDate);
    vDate = DateAdd("s",59,vDate);
    
    return vDate;
}