LASTOFMONTH(theDate)
Description
Returns the date which is the last day of the month from theDate
Example
Dim theDate as Date
Dim result as Date
theDate=DateVal(1999,6,15)
result=LastOfMonth(theDate) 'will calculate result a date of 6/30/1999