Views:

Description

Returns a date which is calculated by adding the number of years parameter (Offset) to the given (Input) date.

Signature

AddYears('datetime', 'numberofyears')

Example

AddYears('08/13/2012', 2) Returns 08/13/2014 (US Format)

Parameters

NameTypeDescriptionRequired
datetimexxxxxxxxxxxx
numberofyearsxxxxxxxxxxxx

Notes: