# AddYears (DateTimeOffset)

| **Name**    | ***AddYears With Offset***                                                                                                                                            |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | AddYears (DateTimeWithOffset date, Integer years)                                                                                                                     |
| Purpose     | To return the date and time after adding the number of years.                                                                                                         |
| Description | Adds or subtracts number of years to/from the specified datetime offset value.                                                                                        |
| Return Type | DateTimeOffset                                                                                                                                                        |
| Parameters  | <p>date \[System.DateTimeOffset] – Date to which years should be added</p><p>years \[System.Int64] – Number of years to be added. To subtract, use negative years</p> |

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

**Example**

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

Where,

*date* = 01/02/2023

*years* = 5

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

In the output window, you can see that the provided integer value, indicating years, 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\(98\).png)
