Forum Discussion
PoweredOut
3 years agoResolver I
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
- PoweredOutResolver I
its always the way after posting. I have my solution
DateTo = Date.Year(DateTime.LocalNow()) +6