GTD sorting question

[janrif]

If I have a filter that includes a range of upcoming appointments amongst other items & I sort up on the appointment column, the items with no appointments went to the bottom, giving priority, i.e. top of list to no appts. If I sorted down appts them came to the top in reverse order, i.e. last appt first, etc.

I also found this true for priority.

Now maybe I'm missing something but it seems to me if I am sorting up on Appt, all apts should come to the top in descending order, i.e. appts closest to today first, etc.

Does this confuse anyone else? Maybe I'm doing something wrong or am mis-interpreting what sort is supposed to do here.

Thank you.