Forum Discussion

PoweredOut's avatar
PoweredOut
Resolver I
3 years ago
Solved

Year.From Calculation

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

 

  • its always the way after posting. I have my solution 

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

     

1 Reply

  • its always the way after posting. I have my solution 

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