Format Dates in GHR to Sort Properly

smodarressiyazdi

What is the secret for getting User-created date field types to sort properly? I have a list that displays a date field that I want to sort by and it does not seem to recognize that months 1-9 in a given year should display before/after months 10-12 depending on the sort. Do I need to collect the date as a different field type and convert it? 

I am not using a set to sort by on the list just basic "sort order is primary, is default descending"

smodarressiyazdi

I think I figured the solution so posting here for future. It looks like by default business classes have a predefined sorting order in GHR...usually HROrganization and the PrimaryKey field. You can figure out the default sorting order by personalizing the list and looking at the sorting panel.

For my user business class this was the case for me.

To be able to sort by the start date field above I had to create a set on my user business class and in the sort order use <PrimaryKeyField>.<DesiredFieldName> . In the example below the key field is AIRJobRequisitions

   

    Sets

       

        ByEstimatedStartDate

            Sort Order

                HROrganization

                AIRJobRequisitions.StartDate

                AIRJobRequisitions