Forum Discussion
Advanced Editor - Date Editor - From today, look 13 full months back
Hi - I am using M in the advanced editor to try and make a dynamic date range. Ideally, I would like to go back 13 months from today's date, but just at the month level. For example, today is May...
jeffshieldsdev
Solution Sage
Solution SageUse Date.StartOfMonth and Date.AddMonths
Date.AddMonths(Date.StartOfMonth(Date.From(DateTime.LocalNow())), -13)