>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?