--Current Date Fin Year Start SELECT DATEADD(year,DATEDIFF(month,'19010701',GETDATE())/12,'19010701') --Current Date Fin Year End SELECT DATEADD(year,1,DATEADD(d,-1,(DATEADD(year,DATEDIFF(month,'19010701',GETDATE())/12,'19010701')))) --Current Date Prev Fin Year Start SELECT DATEADD(year,-1,DATEADD(year,DATEDIFF(month,'19010701',GETDATE())/12,'19010701')) --Current Date Prev Fin Year End SELECT DATEADD(d,-1,(DATEADD(year,DATEDIFF(month,'19010701',GETDATE())/12,'19010701')))