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

    Portal Sort Order Not Sorting




      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?