eomonth() Function

Function

eomonth( starting_date, months )

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

Parameters

Keyword Type Description

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

You can experiment with this function in the test box below.

Test Input

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

Open in Github Built: Thu, Jan 13, 2022 (03:54:03 AM)

On This Page

FEEDBACK