#ENDMTH
Returns the date of the last day of the month in which a date falls.
Syntax:
#ENDMTH date
Examples:
#ENDMTH 3/14/2008 equals 3/31/2008
#ENDMTH 2/1/1980 equals 2/29/1980
#ENDMTH 2/1/1979 equals 2/28/1979
Related Operators:
#BEGMTH
#NEXTBEGMTH