Month Addition

This is a pre-built Action located under the @Generic Element. The functionality of this Action in Avo Assure is to add a specified number of months to the given date based on the format specified in the input value column. The execution status is then stored in a dynamic variable.

Syntax

Input Value: <date>;<number of months>;<current date format>

Argument	Description
<date> (Required)	Provide the starting date
<number of months> (Required)	Provide the number of months to add to the starting date.
<current date format> (Required)	Provide the format of the starting date. Supported date formats: dd/MM/yyyy MM/dd/yyyy MMM/dd/yyyy dd/MMM/yyyy

Output Value: <Dynamic Variable>;<Dynamic Variable>(Optional)

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the updated date after adding the specified number of months.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example: Adding Months to a Date

In this example, we explain how to add a specific number of months to a given date.

• Action: Month Addition

• Input Value: 15/04/2025;3;dd/MM/yyyy

  • The first argument (15/04/2025) specifies the original date.

  • The second argument (3) specifies the number of months to add.

  • The third argument (dd/MM/yyyy) specifies the current date format of the input date.

• Output Value: {Updated Date}

  • The resulting date (15/07/2025) after adding the specified number of months is stored in this {Updated Date} dynamic variable.

  • If a second output variable is provided, then action returns the status as True or False:

    • True: If the month addition is successful.

    • False: If the operation fails due to an invalid date or format.

• Logical Explanation: The Month Addition action fetches the value from the Input Value column (15/04/2025;3;dd/MM/yyyy), adds the specified number of months (3) to the input date, and stores the resulting date (15/07/2025) in the {Updated Date} variable.

Knowledge Bites:

Here are some examples of adding months to a given date in different formats:

Date formats	Input Value	Result
dd/MM/yyyy	15/04/2025;5;dd/MM/yyyy	15/09/2025
MM/dd/yyyy	04/15/2025;2;MM/dd/yyyy	06/15/2025
dd/MMM/yyyy	15/Apr/2025;1;dd/MMM/yyyy	15/May/2025
MMM/dd/yyyy	Apr/15/2025;6;MMM/dd/yyyy	Oct/15/2025