EOMONTH

Returns the date on the last day of a month that falls a specified number of months before or after another date.

Parameter List

Syntax
EOMONTH(start_datemonths)
start_date

The date from which to calculate the result. For example: 2022-02-19.

months

The number of months before or after 'start_date' to consider. For example: 3 or -4.

Examples

EOMONTH("2022-09-02", 3) returns 2022-12-31