SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT 1 AS logcount, 1 AS logUserId, GETDATE() - 130 AS maxlogtm
INTO statslogsummary
UNION ALL
SELECT 2 AS logcount, 2 AS logUserId, GETDATE() - 150 AS maxlogtm
2 rows affected

SELECT *
FROM statslogsummary


logcount
logUserId
maxlogtm


1
1
15/10/2019 17:16:03

2
2
25/09/2019 17:16:03


SELECT logcount, logUserID, maxlogtm, c.daysdiff
FROM statslogsummary s
CROSS APPLY (SELECT DATEDIFF(day, s.maxlogtm, GETDATE()) AS daysdiff) c
WHERE c.daysdiff > 120


logcount
logUserID
maxlogtm
daysdiff


1
1
15/10/2019 17:16:03
130

2
2
25/09/2019 17:16:03
150