I hope this is just me missing something stupid.
I've got a portal that I want sorted by a status field (sort based on Value List) and a Date Field.
I'm getting inconsistent sorts on the date field.
The status is either "Done" or "Open" sorted: Open, Done
The secondary Sort order is the date field descending.
The date field is a date type field with 4 digit year.
I've experimented with setting the sort order in the relationship and in the portal settings.
The majority of the data was imported. The date field was originally a text type. After the data was cleaned up (four digit dates) the field type was changed to date.
I'm betting this is were the problem is.....