Year.From Calculation

[PoweredOut]

Hi

I hope you can help.

I am trying to create a dynamic date table. Part of it is defining a start and end year. To have a dynamic start and end year I am trying this code, which gets me the date, but I want to extract the year only. 

This code gets me the date. 

FromYear = Date.AddYears(Date.From(DateTime.LocalNow()), -3),

I think I have to use the Year.From function, but I have tried a few varicances, but I don't get the result I want.

Can you experst help?

Thanks

Joe

[PoweredOut · Accepted solution]

its always the way after posting. I have my solution 

DateTo = Date.Year(DateTime.LocalNow()) +6