>Created new tables from scratch, entered 100 records. Indexed. Still same problem. The where in the subselect is returning dredeemdat fields that it should not.
>
Ok, first what are the types of the columns?

Secondly, use standard datetime, e.g.

{^1999-12-01}