We are trying to sort the Qualification Summary report by [Skill Expiry Date]. We've opened the report and added the field [Skill Expiry Date] to the top of the [Sort By] selection. The report is being sorted by this field, but it is not sorted correctly.
The report is sorting the field by alpha-numeric rules instead of by date sorting rules. So Feb 1, 2019 is coming before Jan 1, 2017. How do we correct this?
We are using version 9.0.4 on Ubuntu 14.04 with a PostgreSQL database.
Qualification Summary Report - Date Sorting
Re: Qualification Summary Report - Date Sorting
In order for us to assist you please post a copy of the report if possible.
Re: Qualification Summary Report - Date Sorting
The Criteria: The Result NOT sorted by date:In order for us to assist you please post a copy of the report if possible.
Re: Qualification Summary Report - Date Sorting
Do you need any more information?
Re: Qualification Summary Report - Date Sorting
Please upgrade to the latest version of TimeTrex and try it again.
Re: Qualification Summary Report - Date Sorting
We just upgraded to 9.0.9. No change. The report is still sorting incorrectly.
Re: Qualification Summary Report - Date Sorting
Is there anything else we can try?
Re: Qualification Summary Report - Date Sorting
This issue will be resolved in the next version of TimeTrex, due out shortly.