28,409
社区成员




Function MaxDayOfMonth(workdate)
Select Case month(workdate)
Case "1"
maxDay = 31
Case "2" '这里是计算2月份是否闰年
If (year(workdate) Mod 100<>0 and year(workdate) Mod 4 = 0) or (year(workdate) Mod 400 = 0) then
maxDay = 29
Else
maxDay = 28
End If
Case "3"
maxDay = 31
Case "4"
maxDay = 30
Case "5"
maxDay = 31
Case "6"
maxDay = 30
Case "7"
maxDay = 31
Case "8"
maxDay = 31
Case "9"
maxDay = 30
Case "10"
maxDay = 31
Case "11"
maxDay = 30
Case "12"
maxDay = 31
End Select
MaxDayOfMonth = maxDay-int(day(workdate))'这里计算当天距离月底的天数
End Function
for i=0 to MaxDayOfMonth(date())
rs.addnew
rs("ccdate")=DateAdd("d",i,date)
rs.update
next
<%
MaxDayOfMonth= datediff("d",date(),cdate(Year(date()) &"-"& Month(date())+1))
for i=0 to MaxDayOfMonth-1
rs.addnew
rs("ccdate")=DateAdd("d",i,date)
rs.update
next
%>
Function MaxDayOfMonth(workdate)
Select Case month(workdate)
Case "1"
maxDay = 31
Case "2" '这里是计算2月份是否闰年
If (work_year Mod 100<>0 and work_year Mod 4 = 0) or (work_year Mod 400 = 0) then
maxDay = 29
Else
maxDay = 28
End If
Case "3"
maxDay = 31
Case "4"
maxDay = 30
Case "5"
maxDay = 31
Case "6"
maxDay = 30
Case "7"
maxDay = 31
Case "8"
maxDay = 31
Case "9"
maxDay = 30
Case "10"
maxDay = 31
Case "11"
maxDay = 30
Case "12"
maxDay = 31
End Select
MaxDayOfMonth = maxDay-int(day(workdate))'这里计算当天距离月底的天数
End Function
for i=0 to MaxDayOfMonth(date())
rs.addnew
rs("ccdate")=DateAdd("d",i,date)
rs.update
next
Function MaxDayOfMonth(workdate)
Select Case month(workdate)
Case "1"
maxDay = 31
Case "2" '这里是计算2月份是否闰年
If (work_year Mod 100 <> 0 and work_year Mod 4 = 0) or (work_year Mod 400 = 0) then
maxDay = 29
Else
maxDay = 28
End If
Case "3"
maxDay = 31
Case "4"
maxDay = 30
Case "5"
maxDay = 31
Case "6"
maxDay = 30
Case "7"
maxDay = 31
Case "8"
maxDay = 31
Case "9"
maxDay = 30
Case "10"
maxDay = 31
Case "11"
maxDay = 30
Case "12"
maxDay = 31
End Select
MaxDayOfMonth = maxDay-day(workdate)'这里计算当天距离月底的天数
End Function
for i=0 to MaxDayOfMonth(date())
rs.addnew
rs("ccdate")=DateAdd("d",i,date)
rs.update
next