addYear function
The addYear function adds a given number of years to a date attribute.
Parameters
addYear(date, nyear)
Parameter | Description |
---|---|
date | The date attribute we want to add quarters to. The date parameter is mandatory. |
nyear | The number of years to add to the chosen date attribute. The nyear parameter is mandatory. |
Date type valid formats (if the values aren’t this format, the function will return an error).
2019/10/12;
12/10/2019;
2019-10-12;
12-10-2019;
2019/Oct/12;
12/Oct/2019;
2019-Oct-12;
12-Oct-2019.
Example
The following example uses the Bike sales dataset.
Description | Screenshot |
---|---|
In this example, we want to add two years to the Date attribute. We type the following formula in the addqyear attribute:
and the attribute will be filled with the Date attribute’s values postponed by two years. The results are as follows:
|