Query a date field in report builder

[Boise-J-Man]

I can't write a report that queries a access database using a where clause that
uses a variable as the input where the column datatype is 'Date'. I can't seem
to do it. Any Geniuses out there who are smarter than me please help!!!! I
have tried without success to query a access database using a date field as a
constraint & a variable. example 1 select unitname, sum(revenue) as
revenuetotal, sum(runlength) as runtime where (wr.id='#id#' and rundate <
#startdate#) group by unitname example 2 select unitname, sum(revenue) as
revenuetotal, sum(runlength) as runtime where (wr.id='#id#' and rundate <
#2/1/2005#) group by unitname example 1&amp; 2 will both work in the test
mode, but only example 1 will work in an actuall CFMX7 report. the date field,
can't be passed for some reason as a parameter. the # signs are required, and
even if I embed the # signs in the parameter and pass them, it won't work,
other than when I test the query. I can pass parameters to every field except
a date field. I can query the date filed using cfml without a problem, it is
just in the report that is driving me nuts!! I am hoping that I am just
overlooking something. Those of you who use the report tool will run into this
sooner or later, help me solve this one now. Thanks, Jeremy Merritt

[Boise-J-Man]

Problem solved ! the query had to be removed from the report and worked when
placed only in the .cfm file as follows. SELECT UnitName, sum(Revenue) as
rev, sum(RunTimeTotal) as rtt FROM AllActivity where ((id='#ID#') and
((datestamp > ###startdate###) and (datestamp < ###enddate###))) group by
unitname ORDER BY UnitName note the ###