determining 1st monday of each month

or

<cfloop from=1 to=8 index="x" >
      <cfif dayofWeek(createDate(year(now()), month(now()), x)) eq 2>
            <cfoutput>
                  #day(createDate(year(now()), month(now()), x))# is the first Monday
            </cfoutput>
      </cfif>
</cfloop>

Hi, here's a function that performs what you're looking for, just pass year, month, and day of week, it will return the first day of week in month..

rob_lorentz,
  nice code! this function follows the same idea, not a copy just a different way of doing it ;o)
---------------------
<cfscript>
function GetFirstDay(YY,MM,DD){
  Num='';
      for (i=1;i LTE 8;i=i+1){
            if (dayofweek(createdate(YY,MM,i)) eq DD){
                  Num = day(createdate(year(YY),month(MM),i));
                  return Num;
            break;
            }
      }
}
</cfscript>
<!--- function parameters
   GetFirstDay(year,month,day of week)
   day of week is
   1=Sun,2=Mon,3=Tue,4=Wed,5=Thu,6=Fri,7=Sat
   --->
<cfoutput>
First Monday is #GetFirstDay(2006,7,2)#
</cfoutput>

regards,
~trail

It can be done without a loop which would be faster

Here is quick and dirty:

<cfset firstOfMonth = DateFormat(createDate(year(now()), month(now()), 1), "MM/DD/YYYY")>

<cfif DayOfWeek(firstOfMonth) EQ 2>
   <cfset FirstMonday = firstOfMonth>
<cfelseif DayOfWeek(firstOfMonth) EQ 1>
   <cfset FirstMonday = DateAdd("d", 1, firstOfMonth)>
<cfelse>
   <cfset FirstMonday = DateAdd("d", 9 - DayOfWeek(firstOfMonth), firstOfMonth)>
</cfif>

It can actually be even less code using mod arithmetic

More effective (no loops) solution:

<!--- Set month and year --->
<cfset y=2005>
<cfset m=11>

<!--- Find first Monday --->
<cfset d=CreateDate(y, m, 1)>
<cfset n=9-DayOfWeek(d)>
<cfif n GT 6>
   <cfset n=n-7>
</cfif>
<cfset monday=DateFormat(DateAdd("d", n, d), "mm/dd/yyyy")>

<!--- Result --->
<cfoutput>#monday#</cfoutput>

almost the same as  INSDivision6

<cfset d=CreateDate(2005, 10, 1)>
<cfoutput>
#DateFormat(createdate(y, m, (8 - abs(DayOfWeek(d) - 2)) ), 'mm/dd/yyyy')#
</cfoutput>

2 Mouse:

Except when a month starts from Sunday or Monday.  For those cases it creates the date for 2nd monday. With a littlle modification could be used for calculation an election date.

Yes your right!
I gues it could work width some modification.

Maybe another simple solution:
<cfset daylist = "2,1,7,6,5,4,3">
<cfoutput>#DateFormat(createdate(y, m, listgetat(daylist, DayOfWeek(d))), 'dd/mm/yyyy')#</cfoutput>

INSDivision6 don't get me wrong, you got a great solution but I just try to see if there is another simpel solution.