# AddMonths (DateTimeOffset)

| **Name**    | ***AddMonths With Offset***                                                                                                                                                               |
| ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | AddMonths (DateTimeWithOffset 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 offset value.                                                                                                           |
| Return Type | DateTimeOffset                                                                                                                                                                            |
| Parameters  | <p>date \[System.DateTimeOffset] – 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> |

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

**Example**

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

Where,

*date* = 01-02-2023

*months* = 8

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

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

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

Note