Forum Discussion
Solved
M language
Hi I am using the following and it is working well. How can I get dynamically: "today-3 years" and "today + end of next year". For example today is 2024-Oct-29. today-4 years is 2020-Oct-29 toda...
= Date.FromText( Text.From( Date.Year(Date.AddYears( Date.From(DateTime.LocalNow()),1))) & "-12-31")
You can add year to specific date by Date.AddYear and also calculate the last date of a year by Date. EndOfYear.
So your dates can be achieved by the below formual.
Today date => Date.from(DateRime.LocalNow())
Date of next three year=> Date.AddYear(Date.from(DateRime.LocalNow()),3)
End of next year => Date.EndOfYear(Date.AddYear(Date.From(DateTime.LocalNow()),1))
Hi IF ,
Both Omid_Motamedise and SamWiseOwl have provided great solutions. Hope they could help you.
If possible, accept the replies as solutions. This will make it easier for the future people to find the answer quickly.
Best Regards,
Stephen Tao