some one pls help me

when i try to run the below line it generates an error like 'datatype mismathch in criteria expression'

i new to programming..so pls help me

the line goes like this

"select * from mytable where date between '" & Format(DTPicker2.Value, "mm/dd/yyyy") & "' and '" & Format(DTPicker3.Value, "mm/dd/yyyy") & "'"

i need a reply urgently