== really only affects character data and can slow down a query. For dates, you can just use one =.
>
>You can not add NOT EMPTY as a condition, because AFAIK EMPTY is not optimizable. You need to write
>
>not myDateField =={} if you have an index on date.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
