SQL for date. Help

Hi,
How can I perfom an SQL search filtering the date?

Dim DateFrom, DateTo as Date

data1.recordsource "SELECT * FROM database WHERE Date Between ?????????? "

Thanks!

Hi

Code:

---

strDate = Format(Text2.Text, "dd/mm/yy")
strdate2 = Format(Text3.Text, "dd/mm/yy")

Data1.RecordSource = " select * from customerpricelist  where date  between #" & strDate & "# and #" & strdate2 "#"
Data1.Refresh

---

Hope that answer your question

Thank you!