You can use
DISTINCT to avoid duplicate records & you can use
DATEADD() to manipulate with your SELECT statement for Date values.
I have given Sample query so write yourself for your need
SELECT DISTINCT(UserName) FROM TableUser WHERE [Date] < SELECT DATEADD(DAY,1,GETDATE())