CFLib.org – Common Function Library Project

Description:
Returns a date object representing the previous day specified. The default is one week prior to 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 last occurrence of #DayOfWeekAsString(i)# was #DateFormat(PrevOccOfDOW(i), 'mmmm dd, yyyy')#.<BR>
</CFLOOP>
</CFOUTPUT>

Parameters:

Full UDF Source:

/**
 * Returns a date object representing the previous day specified.  The default is one week prior to 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  PrevOccOfDOW()
{
  Var day = DayOfWeek(Now());
  Var dayOffset = 7;
  if(ArrayLen(Arguments)) 
    day = Arguments[1];
  if(Day LT DayOfWeek(Now()))
    dayOffset = 0;    
  return DateAdd("d",- (dayOffset - (day - DayOfWeek(Now()))),Now());
}