From: "Bob Murdoch" <ram5@...>

>
> >What happens if you put "s.account_id=1", instead of "s.account_id in

(1)"?

>
> Same thing - no rows returned.
>
> (The reason for the unusual syntax is that the query is built

automatically

> based on user input. The above syntax allows for multiple accounts to be
> handled without additional processing by the query builder).
>

Why not simply base the date on the same method. IOW, make the date part
alway read:
s.del_date between :Date1 and :Date2

Then, if needed, just set each date to the same for those on a particular
day.

Woody (TMW)