Datareport and sql query

I am trying to create a datareport, so when the user clicks a button, the report will appear, and display only certain info from the database.

The datareport should only show data where the date field is todays date:

i.e. something like this


"SELECT DateOfTask, Task FROM Table1 WHERE DateOfTask =" & " ' " & date & " ' "


How do I do this in the datareport, I have tried typing in the SQL in the data environment, but I just get errors.

I take it you can't use "Date" in the dataenvironment SQL. It doesn't support " or ' either?

Thanks

what database your using? if access try making a query in access then copy the SQL to the dataenvironment SQL...