function GetFirstDay(d as date) as date getfirstday=cdate(year(d) & "-" & month(d) & "-1" end functionfunction GetLastDay(d as date) as date dim M as long dim Y as long y=year(d) m=month(d)+1 if m=13 then getlastday=cdate(cstr(y) & "-12-31") else getlastday=dateadd("d",cdate(cstr(y) & "-" & cstr(m) & "-1"),-1) end if end function随手写的,可能有错误
function GetFirstDay(d as date) as date
getfirstday=cdate(year(d) & "-" & month(d) & "-1"
end functionfunction GetLastDay(d as date) as date
dim M as long
dim Y as long
y=year(d)
m=month(d)+1
if m=13 then
getlastday=cdate(cstr(y) & "-12-31")
else
getlastday=dateadd("d",cdate(cstr(y) & "-" & cstr(m) & "-1"),-1)
end if
end function随手写的,可能有错误