>>My index of a datetime fields appears incorrect
>>
>>Is there a catch to indexing such a field?
>
>If you have a regular index applied on a datetime field, then, there shouldn't be any anomaly. I have been using regular indexes and compound indexes on such field for years and it turned out to work very well.
>
>Can you elaborate more on what is not working exactly?
I have reindexed and it now appears to be working
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing