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!