4 Replies Latest reply on Aug 6, 2017 2:10 PM by boilinh2o

    Portal Sort Order Not Sorting

    boilinh2o

      Hi,

       

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

       

      Any thoughts?

       

      Thanks!

       

      Mark