Antoher approach is to create a view, and in you WHERE clause use a variable
WHERE datefield = ?m.parameterdate.
Build your report on the view, then at run time, you can either provide a value in code, or if you do not, the app will prompt for a value prior to running the report.