Hello all. I have a page which is supposed to show all records BETWEEN " & StartDate & " AND " & EndDate & ". The error I am getting is a Data Type Mismatch.

I am populating the variables by:

 
<%
Dim StartDate, EndDate
StartDate = rsDate.Fields.Item("tblWed").Value
EndDate = rsDate.Fields.Item("tblTues").Value
%>

My dates are being input into an Access DB as date, although the following SQL statement is causing the error for some reason:

 
SELECT *
FROM tblEmpTime
WHERE dbEmpLogin = 'MMColParam' AND WorkDate BETWEEN '" & StartDate & "' AND '" & EndDate & "'
ORDER BY WorkDate ASC

I would greatly appreciate any ideas.

Thanks,

Parallon

cast the variables to date type with cdate(string)