I have a query in my Access ADP project where I want to check a series of dates who are in the future (including if they match today). I can not use now() or getdate() as they will look at the time as well.
If found a T-SQL function, to be able to check on the date only.. but it still does not work
When I use : WHERE dbo.UserId.Date_removed >= GetDate() the query returns all future dates, but not the one who match today.
SELECT dbo.UserId.Date_removed FROM dbo.UserId INNER JOIN
dbo.Department ON dbo.UserId.Department = dbo.Department.dep_id
WHERE dbo.UserId.Date_removed >=
(SELECT DATEADD(dd, DATEDIFF(dd, 0, GetDate()), 0)