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:
Code:
<%
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:
Code:
SELECT *
FROM tblEmpTime
WHERE dbEmpLogin = 'MMColParam' AND WorkDate BETWEEN '" & StartDate & "' AND '" & EndDate & "'
ORDER BY WorkDate ASC
I would greatly appreciate any ideas.
Thanks,
Parallon
Last edited by parallon; 06-28-2006 at 03:21 PM..
|