strsql = "select * from visitas where dni= "'"& request.form("comercial") &"'" and fecha="'"&Cdate(request.form("f echa")&"'"
strsql = "select * from visitas where dni= "'"& request.form("comercial") &"'" and fecha="#"&Cdate(request.form("f echa")&"#"
Prueba y nos avisas
<center><img src="http://www.pcmasmas.com.ar/foro/images/avatars/043.gif"><br>
Urjose</center>