edate() Function

Returns the date that is the number of months before or after the given starting date.

Syntax

edate( starting date, months )

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

FEEDBACK