Im trying to search a MS Access database for a specific date. Im getting a an error message, translated to english its something like: "typeerror in query". The column's type is a Date/Time with the format short date.

the query is as follows:
SELECT Personel.Sign, Personel.Firstname, Personel.Lastname, Absent.Date
FROM Personel, Absent
WHERE Absent.Date = '" & datetimepicker.Value.Date & "' AND Personel.Sign = Absent.Teacher_Sign

Would really appreciate help