Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DaysInMonth() 1
- Thread starter KevinFSI
- Start date
- Thread starter
- #3
-
1
- #4
Hey Kevin,
I remember a post on March 8 where I posted some code to do something similar. This should give a reasonable accurate number for you. It starts with the day after sDate and counts days up to and including eDate.
<cfset workDays=0>
<cfloop index="x" from=1 to=#datediff("d",sDate,eDate)#>
<cfif dayofweek( dateAdd("d",x,sDate)) neq 1 and dayofweek(
dateAdd("d",x,sDate)) neq 7>
<cfset workDays=workDays + 1>
</cfif>
</cfloop>
Hope this helps,
GJ
I remember a post on March 8 where I posted some code to do something similar. This should give a reasonable accurate number for you. It starts with the day after sDate and counts days up to and including eDate.
<cfset workDays=0>
<cfloop index="x" from=1 to=#datediff("d",sDate,eDate)#>
<cfif dayofweek( dateAdd("d",x,sDate)) neq 1 and dayofweek(
dateAdd("d",x,sDate)) neq 7>
<cfset workDays=workDays + 1>
</cfif>
</cfloop>
Hope this helps,
GJ
- Thread starter
- #5
That's correct. I think the only thing to watch out for is how it treats the starting and ending days. Currently, the starting date is not counted and the ending date is counted. You can easily modify the code to alter this but I just coded it this way because it was less complicated.
GJ
GJ
- Thread starter
- #7
- Status