Subtract two dates in SQL and get days of the result May 31, 2023 by Tarik Use DATEDIFF Select I.Fee From Item I WHERE DATEDIFF(day, GETDATE(), I.DateCreated) < 365