Get current year in TSQL November 22, 2023 by Tarik Yes, it’s remarkably easy in fact: WHERE YEAR(A.[reimbursementDate]) = YEAR(GETDATE())