Page 1 of 1

Qualification Summary Report - Date Sorting

Posted: Sun Mar 13, 2016 10:25 pm
by Yajasi
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.

Re: Qualification Summary Report - Date Sorting

Posted: Mon Mar 14, 2016 8:17 am
by shanec
In order for us to assist you please post a copy of the report if possible.

Re: Qualification Summary Report - Date Sorting

Posted: Tue Mar 15, 2016 9:43 pm
by Yajasi
In order for us to assist you please post a copy of the report if possible.
The Criteria:
TTcriteria.png
The Result NOT sorted by date:
TTsort.png

Re: Qualification Summary Report - Date Sorting

Posted: Mon Mar 21, 2016 9:30 pm
by Yajasi
Do you need any more information?

Re: Qualification Summary Report - Date Sorting

Posted: Tue Mar 22, 2016 7:12 am
by shaunw
Please upgrade to the latest version of TimeTrex and try it again.

Re: Qualification Summary Report - Date Sorting

Posted: Wed Mar 23, 2016 3:44 pm
by Yajasi
We just upgraded to 9.0.9. No change. The report is still sorting incorrectly.

Re: Qualification Summary Report - Date Sorting

Posted: Tue Apr 05, 2016 4:00 pm
by Yajasi
Is there anything else we can try?

Re: Qualification Summary Report - Date Sorting

Posted: Tue Apr 05, 2016 4:39 pm
by shaunw
This issue will be resolved in the next version of TimeTrex, due out shortly.