I was a bit confused why modification of your query did not get what I wanted when I tried to replace eomonth by year. Finally I realized that I need a date and year returns int - so I'd need something like datefromparts(year(getdate()),1,1). data.stackexchange.com/meta.mathoverflow/query/1618575