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