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!

[CoMMiE]

Hi


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!