addMonth function in the Factory
The addMonth function adds a given number of months to a date attribute.
Parameters Parameter Description date The date attribute we want to add months to. The date parameter is mandatory. nmonth The number of months to add to the chosen date attribute. The nmonth 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.addMonth(date, nmonth)
Example
The following example uses the Bike sales dataset.
Description | Screenshot |
|---|---|
In this example, we want to add 2 months to the reported date, which is the attribute Date. We type the following formula in the addmonth attribute:
and the attribute will be filled with the Date attribute’s values postponed by two months. The results are:
|  |