Or this:

with MaxDate as (

select

max(dateadd(month, MonthValue - 1, dateadd(year, YearValue - 1900, 0))) as MaxDate

from

dbo.DealerForecastSegmentValue

)

select

md.MaxDate,

dateadd(month, -23, md.MaxDate) as MinDate

from

MaxDate;