Forum Discussion
Anonymous
4 years agoNot applicable
Set end date calendar to next 3 months
Hello,
I have a calendar table in Power Query with the end date dynamically calculated using the following step:
= Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow()))But i want to change this expression to be always 3 months from today, so that means it should also go forward to the next year, for example, if today is 10 December 2022, then it should go forward 3 months into March 2023.
Is that possible? Any help is much appreciated.
- Anonymous4 years ago
Hi Anonymous
Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()),3)
1 Reply
- AnonymousNot applicable
Hi Anonymous
Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()),3)