Date.AddYears
Moves a date, datetime or datetimezone by whole calendar years.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.AddYears(dateTime as any, numberOfYears as number) as any| Parameter | Type | Description |
|---|---|---|
dateTime | any | The date, datetime or datetimezone to move; null gives null. |
numberOfYears | number | How many years to move: negative goes back in time. |
Returns
any. The same kind of value as given, moved by that many years.
Remarks
- A date gives a date, a datetime a datetime, a datetimezone a datetimezone with its offset unchanged; the time of day is kept.
- 29 February moved to a year that is not a leap year becomes 28 February.
Examples
The same day last year
Date.AddYears(#date(2024, 3, 15), -1)#date(2023, 3, 15)A leap day one year on
Date.AddYears(#date(2024, 2, 29), 1)#date(2025, 2, 28)2025 has no 29 February: the answer is the 28th.