Try something like

Report.SelectionFormula = "{TABLENAME.FIELDNAME} > " _
"Date(01,01,1999) AND "{TABLENAME.FIELDNAME} < " _
"Date(10,10,1999)"

ReportTest.PrintReport

If you require the date to be unput at runtime you will have to convert the input into the format Date(dd,mm,yyyy).

Hope this works

-Jamie One-