How can I sort the items?

I have a table with customer items. I want to sort these by date or order number (both good)
But if I choose sorting a-z or vice versa. It is not sorted. One is a text field and the other is a date field.
How can I sort these in order?

I prefer by order number (textfield)