LastOfMonth                                                                                           Function

 

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