Add Months

This function adds a specific number of months (for example, 5) to a timeline with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to add 5 months to the 05/03/24 (5 March, 2024) date. After you use the ADDMONTHS() function to add 5 months to the 05/03/24 date, it performs the addition and then returns the 05/08/24 (5 August, 2024) date.

You can use the ADDMONTHS function as follows:

To use the ADDMONTHS function:

1. Click in the smart selector to display the Search box.

2. In the Search box, enter addmonths to display the ADDMONTHS function.

3. In the list, select the ADDMONTHS function to display it with the date, format, and months parameters.
4. In the ADDMONTHS function, click Date to display the Search box.
5. In the Search box, enter static to display the Static function.

6. In the list, select the Static function to display it with the value and the String parameters.
7. In the Static function, click the value parameter and then enter a date (for example, 05/03/24 or 05/03/2024) in dd/mm/yy or dd/mm/yyyy format.

Note:- If you do not want to enter the date manually by using the Static function, you can fetch the value of the date from an element or entity. To know more about defining the value in entity, click here and then access the heading section: Sample JSON Structure with Key/Value Pair.

8. In the ADDMONTHS function, click the format parameter and then enter dd/mm/yy in the place of the format parameter.

9. In the ADDMONTHS function, click the months parameter to display the Search box.
10. In the Search box, enter static to display the Static function.

11. In the list, select the Static function to display it with the value and the Integer parameters.
12. In the Static function, click the value parameter and then enter a value (for example, 5) that you want to add to the earlier defined date (05/03/24).