# AddYears (DateTime)

| **Name**    | ***AddYears***                                                                                                                                                                  |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | AddYears (Date date, Integer years)                                                                                                                                             |
| Purpose     | To return the date and time after adding or subtracting the number of years.                                                                                                    |
| Description | Adds or subtracts number of years to/from the specified datetime value.                                                                                                         |
| Return Type | DateTime                                                                                                                                                                        |
| Parameters  | <p>date \[System.DateTime] – Date to/from which years should be added/subtracted</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\(98\).png)

**Example**

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

Where,

*date* = 01-01-2022

*years* = 10

<figure><img src="https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20(99).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 value.

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