CFLib.org – Common Function Library Project

Description:
Returns the week number in a month for any given date (1-5).

Return Values:
Returns a number.

Example:

<cfscript>
myDate = CreateDate(2014, 6, 27);
weekOfMonth = getWeekOfMonth(myDate);
// returns 4
</cfscript>

Parameters:

Full UDF Source:

/**
 * Returns the week number in a month for any given date (1-5).
 * 
 * @param d      Date to parse. (Required)
 * @return Returns a number. 
 * @author Stephen Withington (stephenwithington@gmail.com) 
 * @version 0, November 13, 2014 
 */
numeric function getWeekOfMonth(date d=Now()) {
    var cal = CreateObject('java', 'java.util.GregorianCalendar').init(
        JavaCast('int', Year(arguments.d))
        , JavaCast('int', Month(arguments.d)-1)
        , JavaCast('int', Day(arguments.d))
        , JavaCast('int', Hour(arguments.d))
        , JavaCast('int', Minute(arguments.d))
        , JavaCast('int', Second(arguments.d))
    );
    cal.setMinimalDaysInFirstWeek(1);
    return cal.get(cal.WEEK_OF_MONTH);
}