AddMonths (DateTime)

Name

AddMonths

Syntax

AddMonths (Date date, Integer months)

Purpose

To return the date and time after adding or subtracting the number of months.

Description

Adds or subtracts number of months to/from the specified datetime value.

Return Type

DateTime

Parameters

date [System.DateTime] – Date to/from which months should be added/subtracted

months [System.Int64] – Number of months to be added. To subtract, use negative months

Example

In this example, we will pass a date time value, and an integer value (indicating months to be added or subtracted) to the function transformation object using a Variables object.

Where,

date = 01-01-2022

months = 5

In the output window, you can see that the provided integer value, indicating months, has been added to the given date time value.