EOMONTH function

EOMONTH (Date, Months?) EOMONTH (Date; Months?)

Date

Temporal Temporal

The start date.

Number Number (optional)

The number of months the start date should be advanced or set back. If omitted, 0 is assumed.

Temporal Temporal

A date representing the last day of a particular month.

Returns a date representing the last day of a particular month, potentially set back or advanced a number of months.

EOMONTH ( DATE (1981, 5, 1), 0)

EOMONTH ( DATE (1981; 5; 1); 0)

Returns a date representing May 31, 1981.

EOMONTH ( DATE (1981, 5, 14), 0)

EOMONTH ( DATE (1981; 5; 14); 0)

Returns a date representing May 31, 1981.

EOMONTH ( DATE (1981, 6, 1), 24)

EOMONTH ( DATE (1981; 6; 1); 24)

Returns a date representing June 30, 1983 (June 1, 1981, advanced 24 months).

EOMONTH ( DATE (1981, 11, 14), - 24)

EOMONTH ( DATE (1981; 11; 14); - 24)

Returns a date representing November 30, 1979 (November 14, 1981, set back 24 months).