>>>My index of a datetime fields appears incorrect
>>>
>>>Is there a catch to indexing such a field?
>>
>>What exactly do you mean? Is it a single column index?
>
>The format of the field is day month year Hour Mins
Post your table definition and your index definition. If it's the datetime column, then it should be sorted correctly if index is on the column.
If it's not broken, fix it until it is.
My Blog