CFLib.org – Common Function Library Project

Description:
Returns a date object representing the next occurrence of the specified day. The default is the next occurrence of the current day.

This function is based on an idea submitted by Larry Juncker (ljuncker@aljcompserv.com).

Return Values:
Returns a date.

Example:

<CFOUTPUT>
<CFLOOP INDEX="i" FROM="1" TO="7">
The next occurrence of #DayOfWeekAsString(i)# is #DateFormat(NextOccOfDOW(i), 'mmmm dd, yyyy')#.<BR>
</CFLOOP>
</CFOUTPUT>

Parameters:

Full UDF Source:

/**
 * Returns a date object representing the next occurrence of the specified day.  The default is the next occurrence of the current day.
 * This function is based on an idea submitted by Larry Juncker (ljuncker@aljcompserv.com).
 * 
 * @param day      Ordinal day of the week.  1=Sunday, 2=Monday, 3=Tuesday, etc.   
 * @return Returns a date. 
 * @author Rob Brooks-Bilson (rbils@amkor.com) 
 * @version 1, August 22, 2001 
 */
function  NextOccOfDOW()
{
  Var day = DayOfWeek(Now());
  Var dayOffset = 7;
  if(ArrayLen(Arguments)) 
    day = Arguments[1];
  if(Day GT DayOfWeek(Now()))
    dayOffset = 0;
  return DateAdd("d",(dayOffset + (day - DayOfWeek(Now()))),Now());    
}