Returns the date for the last day of the month that is the number of months before or after the given starting date.

Syntax

eomonth( starting date, months )

starting_date: (Date) The starting date.

months: (Integer) The number of months to offset, where negative is before starting_date and positive is after starting_date.

Returns

Date

Examples

eomonth(date(2011,12,13),-6) returns 6/30/2011