function getLastdayOfYear( iYear as integer ) as string
getLastdayOfYear=format(trim(Str(iyear)) + "-12-31","yyyy-mm-dd")
end functionFunction getLastdayOfMonth(iYear as integer ,iMonth as Integer) as string
dim t as string
if imonth >=12 then
t=Trim(str(iYear+1)) + "-01-01"
else
t=Trim(Str(iyear )) + "-" + trim(str(imonth+1)) + "-01"
t=format((cdate(t)-1),"yyyy-mm-dd")
end if
t=format(t,"yyyy-mm-dd")
getLastdayOfMonth=tend Function
getLastdayOfYear=format(trim(Str(iyear)) + "-12-31","yyyy-mm-dd")
end functionFunction getLastdayOfMonth(iYear as integer ,iMonth as Integer) as string
dim t as string
if imonth >=12 then
t=Trim(str(iYear+1)) + "-01-01"
else
t=Trim(Str(iyear )) + "-" + trim(str(imonth+1)) + "-01"
t=format((cdate(t)-1),"yyyy-mm-dd")
end if
t=format(t,"yyyy-mm-dd")
getLastdayOfMonth=tend Function
解决方案 »
- with的用法
- 如何随机生成A-Z,a-z 52个大小字符中的任意一个
- 急急急急急急急急急急急,菜鸟求教,文件夹右键原理提问,急急急急急急急急
- 急急急急急急急急急急急,菜鸟求教,如何让LISTBOX或者DataGrid实现如下的效果,急急急急急急急急
- 水贴,进来都有分拿
- ActiveSkin使用问题
- 如何用vb自动开设webeasymail,imail,MDaemon这些邮件服务器里的帐号呢?(快来拿走你该拿的分)
- 半年后工作是学习vb还是vc好一点呢?
- 老问题,关于系统托盘的,连vb都推出去了,以前我添加没有问题的呀!
- 请问一个月薪水的问题!
- 急!!!今天去应聘,成功了!公司要求我做一份公司网站策划书!请问各位高手如何策划好一个企业网站呀!100分相送
- 请各位大侠帮一下忙
Function getLastdayOfMonth(iYear as integer ,iMonth as Integer) as string
dim t as string
if imonth >=12 then
t=Trim(str(iYear+1)) + "-01-01"
else
t=Trim(Str(iyear )) + "-" + trim(str(imonth+1)) + "-01"
end if
t=format((cdate(t)-1),"yyyy-mm-dd")
getLastdayOfMonth=tend Function
Function getLastdayOfMonth(iYear as integer ,iMonth as Integer) as string
dim NextMonthStartDate as string
NextMonthStartDate=cstr(iYear)+"-"+cstr(iMonth+1)+"-01"
getLastdayOfMonth=cstr(dateadd("d",-1,nextmonthstardate))
end Function