– Common Function Library Project

GetLastOccOfDayInMonth(TheDayOfWeek, TheMonth, TheYear)

Last updated August 22, 2001

Version: 1 | Requires: ColdFusion 5 | Library: DateLib

Rated 0 time(s). Average Rating: 0

Returns the day of the month(1-31) of Last Occurrence of a day (1-sunday,2-monday etc.) in a given month. Can be used to determine holidays or special events that occur on the last occurrence of a day in a month.

Return Values:
Returns a numeric value.


view plain print about
The last Monday in May of 2001 is on May #GetLastOccOfDayInMonth(2,5,2001)#.


Name Description Required
TheDayOfWeek Ordinal value representing the desired day of the week (1-sunday,2-monday etc.) Yes
TheMonth Ordinal value representing the month (1-January, 2-February, etc.) Yes
TheYear The year. Yes

Full UDF Source:

view plain print about
 * Returns the day of the month(1-31) of Last Occurrence of a day (1-sunday,2-monday etc.)
in a given month.
 * @param TheDayOfWeek      Ordinal value representing the desired day of the week (1-sunday,2-monday etc.) 
 * @param TheMonth      Ordinal value representing the month (1-January, 2-February, etc.) 
 * @param TheYear      The year. 
 * @return Returns a numeric value. 
 * @author Ken McCafferty ( 
 * @version 1.0, August 22, 2001 

function GetLastOccOfDayInMonth(TheDayOfWeek,TheMonth,TheYear) 
  //Find The Number of Days in Month
  Var TheDaysInMonth=DaysInMonth(CreateDate(TheYear,TheMonth,1));
  //find the day of week of Last Day
  Var DayOfWeekOfLastDay=DayOfWeek(CreateDate(TheYear,TheMonth,TheDaysInMonth));
  //subtract DayOfWeek
  Var DaysDifference=DayOfWeekOfLastDay - TheDayOfWeek;
  //Add a week if it is negative
  if(DaysDifference lt 0){
    DaysDifference=DaysDifference + 7;
  return TheDaysInMonth-DaysDifference;
blog comments powered by Disqus


Latest Additions

Adam Cameron Adam Cameron added
14 day(s) ago

Ray Ford Ray Ford added
29 day(s) ago

Henry Ho Henry Ho added
a while ago

Rick Root Rick Root added
a while ago

Top Rated

Darwan Leonardo Sitepu backupDatabase
Rated 5.0, 48 time(s)

Barney Boisvert indentXml
Rated 5.0, 12 time(s)

Rachel Lehman deAccent
Rated 5.0, 9 time(s)

Darwan Leonardo Sitepu splitNumber
Rated 5.0, 8 time(s)

Created by Raymond Camden / Design by Justin Johnson