# 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  | <p>date \[System.DateTime] – Date to/from which months should be added/subtracted</p><p>months \[System.Int64] – Number of months to be added. To subtract, use negative months</p> |

**Example**

<figure><img src="https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20(94).png" alt=""><figcaption></figcaption></figure>

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

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(95\).png)

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

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(95\).png)