edate() Function

Function

edate( starting_date, months )

Returns the date 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

edate(date(2011,12,13),-6) returns 6/13/11

Open in Github Built: Mon, Nov 15, 2021 (03:03:53 PM)

On This Page

FEEDBACK