Forum Discussion
M Query - January 1st of Previous Year
Hi all,
I'm looking for an M Query assist.
I'd like to set my StartDate to January 1st of the previous year, and my EndDate to the current day. So, start date should read 01-01-2020 and EndDate should read (today, so 09-23-2021). How would I cast that in M Query?
let StartDate = ...?
let EndDate = Date.From(DateTime.LocalNow()) ...?
Thank you!
Anonymous
let EndDate = Date.From(DateTime.LocalNow()) let StartDate = #date(Date.Year(EndDate)-1,1,1)
2 Replies
- AlexisOlson
Super User
Another way would be to use the Date.StartOfYear and Date.AddYears functions.
StartDate = Date.From(Date.StartOfYear(Date.AddYears(DateTime.LocalNow(), -1)))
- Greg_Deckler
Community Champion
Anonymous
let EndDate = Date.From(DateTime.LocalNow()) let StartDate = #date(Date.Year(EndDate)-1,1,1)
