Date param hitting date/time field 1

[MaumeeScott]

I have date parameters (?StartDate and ?EndDate) and they are being run against a date/time field. The selection criteria looks like:

Date({date/time field}) in ?StartDate and ?EndDate

This works fine except that it takes forever to run and no matter what date range in insert the report looks at every record. When I remove the Date() function it is much faster. I would like for my users not to have to deal with a time-stamp on the parameter if possible. Any ideas?

 

[dtempleton]

What about:

{date/time field} in datetime({?StartDate}, time(0,0,0)) to datetime({?EndDate}, time(23,59,59))

 

[synapsevampire]

What you saw happening is that the SQL wasn't being passed to the database.

Make sure that anything you reference in the record selection is also represented in the Databse->Show SQL Query.

I have a FAQ on this topic:

faq767-3825

-k