You need to check that the CurDate is in a range from midnight last night up to, but not including, midnight tonight. i.e.SELECT [LastNight] = DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0), [Tonight] = DATEADD(day, DATEDIFF(day, 0, GETDATE())+1, 0)
thus you should be able to find the relevant rows with:SELECT [Last Name], [First Name], [Middle Initial], SS#, [Dept #]FROM dbo.[Nurse Orientation - tbl]WHERE CurDate >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) AND CurDate < DATEADD(day, DATEDIFF(day, 0, GETDATE())+1, 0)
Kristen