EOMONTH

The EOMONTH function takes a date as input and returns the last day of the month, which is a specified number of months from the input date. Node references are also accepted as arguments. Use DATE.SET() to set the format of the output date.

Syntax

eomonth(date, value)

Arguments

date – The date which is passed as input to the function.

value – The number of months to be added to the input date. Can be positive or negative.

Return value

Date

Example

EOMONTH('8/15/2023', 3)

Returns 30/11/2023.

EOMONTH