In that case, the Date would be indexed properly, but it won't solve the original problem. IMO, when indexing on a date it is better to use DTOS because it is clearer what is happening.
>
>Well ... DTOC(...,1) I'd say. Or ?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
