Don't pass dates as strings: send them as DateTime objects. To strip the time off a DateTime is easy:
cmd.Parameters.AddWithValue("@date", DateTime.Now.Date);
This "resets" the time component to midnight.
Then do the comparison:
WHERE DeviceLogs.UserId = Employees.EmployeeCode) AND CAST(LogDate AS DATE) = @date
and it should all work.