M Query - January 1st of Previous Year

[dkpcr5]

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!

[AlexisOlson]

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 · Accepted solution]

@dkpcr5 

let EndDate = Date.From(DateTime.LocalNow())
let StartDate = #date(Date.Year(EndDate)-1,1,1)