SQL Query formula fecha automatica?

Hola buen dia,

necesito ayuda con este query en SQL donde tengo que hacer que las dos fechas que estan en bold “CAMBIEN AUTOMATICAMENTE cada mes y cada año” en el futuro. alguna idea?

SELECT a.PatientId,a.DataSourceKey
,c.RosterMonth
,a.AppointmentDate
,a.VisitType
,a.NewPatient
,a.ResourceProviderNPI
,a.ResourceProviderName
,a.OriginalPatientName
,a.IsProviderVisit
,a.VisitStatus
,b.MBI
,c.OriginalLOB
,c.OriginalPayer
,f.Grouping
,f.PracticeShortName
,a.isTelehealth
FROM [cube].FactVisits a
LEFT JOIN [cube].Patient b
ON a.PatientId=b.PatientId
LEFT JOIN [cube]. FactPayersEnrollmentRoster c
ON a.PatientId=c.PatientID
LEFT JOIN [cube].vAttributedProvider e
ON c.AttributedProviderID = e.AttributedProviderID
LEFT JOIN [cube].vLocationAttributed f
on e.PrimaryLocationId = f.LocationId
WHERE AppointmentDate between ‘2023-01-01’ AND ‘2023-12-31’–DOS YTD —
AND VisitStatus in (‘checked-out, ‘pending’)
AND IsProviderVisit like ‘Y’
AND c.RosterMonth like ‘2023-08-01‘–Change to current roster month —
AND c.OriginalLOB = ‘commercial exchange’
GROUP BY a.PatientId,a.DataSourceKey,c.RosterMonth, a.AppointmentDate,a.VisitType,a.NewPatient,a.ResourceProviderNPI,a.ResourceProviderName,a.OriginalPatientName,a.IsProviderVisit,a.VisitStatus
, b.MBI,c.OriginalLOB,c.OriginalPayer,f.Grouping,f.PracticeShortName, a.isTelehealth