Home > Expression Operators > Date Operators > #ENDMTH

#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