I AM GETTING RUN-TIME ERROR '-2147217913(80040e07)":

[MICROSOFT][OBDBC SQL Server Driver][SQL sERVER] Conversion failed when Converting The varchar value '9/1/2012' to data type int. ------[ 9/1/2012 ] value of date1


Recdz.Open "Select RTRIM(tblTicket.TicketNo),(tblTicket.LicenseNumber),RTRIM(tblTicket.Lname) + ',' + RTRIM(tblTicket.Fname) + ',' + RTRIM(tblTicket.Mna
me) as 'FullName',tblTicket.location as 'Address',tblTicket.PlaceOfViolation,tblTicket.DateAndTime,violation.violation from tblTicket,violation

---------------[Selecting Fields]
_________________________________________

where

CONVERT(varchar(20),cast(datepart(mm,DateAndTime) as varchar (10)) + '/' + cast(datepart(dd,DateAndTime) as varchar (10)) + '/' + cast(datepart(yy,DateAndTime) as varchar (10)),101) >= " & Date1 & "
------------- [Start Date]
AND

CONVERT(varchar(20),cast(datepart(mm, DateAndTime ) as varchar (10)) + '/' + cast(datepart(dd,DateAndTime) as varchar (10)) + '/' + cast(datepart(yy,DateAndTime) as varchar (10)),101) <= " & Date2 & " AND (tblticket.violationID = violation.ID)"
----------[End Date]
____________________________________________
,dbconn2, adOpenDynamic, adLockReadOnly --- Connection

Date1 and Date2 is Declared as Date

DateAndTime is a Field in SQL Declared as DateTime

help me please

date1 and date2 returns mm/dd/yyyy in VB when excuted as well as converted DateAndTime when i run in SQL Query

can someone help me or can u suggest new codes if it is wrong?

THE CODE SHOULD FILTER THOSE PEOPLES WHO VIOLATED IN A SPECIFIC RANGE OF DATES