last day of month 2

[obuspider]

Is There a way to easily determine the last day of the month?

 

[madhouse]

Try this function:

Function LastdayInMonth(byVal datDate)
'move to the next month
datDate = dateadd("m",1,datDate)
'move back one day from first day in this month
datDate = dateadd("d",-1,month(datDate) & "/1/" & year(datDate))
'return date as last day in this month
LastdayInMonth= datDate
End Function

 

[newbiepg]

yes
if a variable mydate contains the month
1 is for january, 2 for february and so on
do this

reqdate = cDate((mydate+1) & "/1/" & year(now))
reqdate = cDate(reqdate -1)

this will give you the last date

You can of course put it in a function too