INCDATE
Syntax
INCDATE (Date, Months, Years)
Description
The INCDATE returns the value of Date incremented by Months and Years.
Returns
The value of Date incremented by Months and Years.
Example
If Date contains
the date 2001/04/18, INCDATE(Date, 3, 2) returns the date 2003/07/18.
If Date falls on
the last day of a month, INCDATE returns
a date that falls on the last day of a month, even if it has to change
the day. For example, if Date contains
the date 2003/04/30, then INCDATE(Date, 3, 2) returns the date 2005/07/31 rather than 2005/07/30. Because Date contains
the last day of April, INCDATE returns
the last day of July.
Suppose that an analytic model contains a data cube called HIRE_DATE that uses a dimension called EMPLOYEES. Company policy starts benefits for an employee three months after the hire date. The following formula calculates the benefits date for each employee as follows:
INCDATE(HIRE_DATE, 3, 0)Related Topics