>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}
If it's not broken, fix it until it is.
My Blog