Eomonth

eomonth returns the date of the last day of the month in the year for the date given in the parameter.

Syntax

 eomonth(DATE_EXPR)

• DATE_EXPR is an expression returning a date value.

Examples

 # Last date of the current monthLocal Date LAST_DATELAST_DATE=eomonth(date$)# Returns [31/1/2013]Local Date LAST_JANUARYLAST_JANUARY=eomonth([5/1/2013])

Description

eomonth returns the last day of a month for the date given as a parameter. The type of result is Date.

When the date is a null date ([0/0/0]), the function returns a null date.

Associated errors

See also

day, month$, month, year, day$, nday, date$, datesyst, gdat$, Date.