--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')))

 

Share This Via: