query between campi data

[Mems]

<%
SQL="SELECT * FROM scontrini WHERE data BETWEEN #"&data1&"# AND #"&data2&"#"

Set rec = Server.CreateObject("ADODB.Recordset")
Set rec=Conn.Execute(SQL)
%>