I am trying to create an option in my CF calendar that allows repeating
events that relocate themselves to the first business day of the month. For
example, if the 1st falls on a Saturday, relocate that event to the 3rd, or
Monday, the first business day. I have a problem with FirstDayOfMonth,
however - it keeps returning the wrong day (one day earlier than it
should). Here is my example code, with April 1, 2001 hard coded in since
April 1st falls on a Sunday:
<cfset thedate="04/01/2001">
<CFOUTPUT>
<P>
Date: #dateFormat(thedate, "mm/dd/yyyy")#.
<BR>This date is a #DayofWeekAsString(DayOfWeek(thedate))#, day
#DayOfWeek(thedate)# in the week.
<BR>This is day #Day(thedate)# in the month of
#MonthAsString(Month(thedate))#, which has
#DaysInMonth(thedate)# days.
<BR>This date is in week #Week(thedate)# of #Year(thedate)# (day
#DayofYear(thedate)# of #DaysinYear(thedate)#).
<BR><CFIF IsLeapYear(Year(thedate))>This date is in a leap year
<CFELSE>This date is not in a leap year</CFIF>
<P>
The first day of #DateFormat(thedate,"mmmm")#,
#DateFormat(thedate,"YYYY")# is
a #DayOfWeekAsString(DayOfWeek(FirstDayOfMonth(thedate)))# *****NOTE*****
(<B>this should return Sunday but returns Saturday</B>),
day #FirstDayOfMonth(thedate)# of the year.
<P>
The first day of the month is: #DayOfWeek(FirstDayOfMonth(thedate))#
*****NOTE***** (<B>This should return 1 but returns 7</B>)
<cfif DayOfWeek(FirstDayOfMonth(thedate)) IS 7>
<P>
<cfset FirstBusinessDay = DateAdd("d",2,thedate)>
first business day = #DateFormat(firstbusinessday,"dddd, mmmm dd, yyyy")#
*****NOTE***** (<B>This should return Monday, 04/02/2001 but returns
Tuesday, 04/03/2001</B>)
<cfelseif DayOfWeek(FirstDayOfMonth(thedate)) IS 1>
<P>
<cfset FirstBusinessDay = DateAdd("d",1,thedate)>
first business day = #dateformat(firstbusinessday,"dddd, mmmm dd, yyyy")#
</CFIF>
</CFOUTPUT>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
