Delicious      Technorati      Blinklist      Furl      Reddit

TimeTrex Time and Attendance

TimeTrex Time and Attendance


* FAQ    * Search
* Login   * Register

All times are UTC - 8 hours [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
PostPosted: Sun Mar 13, 2016 10:25 pm 
Offline

Joined: Wed Oct 17, 2012 4:48 pm
Posts: 108
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.


Top
 Profile  
 
PostPosted: Mon Mar 14, 2016 8:17 am 
Offline

Joined: Thu Apr 25, 2013 8:22 am
Posts: 374
In order for us to assist you please post a copy of the report if possible.


Top
 Profile  
 
PostPosted: Tue Mar 15, 2016 9:43 pm 
Offline

Joined: Wed Oct 17, 2012 4:48 pm
Posts: 108
Quote:
In order for us to assist you please post a copy of the report if possible.

The Criteria:
Attachment:
TTcriteria.png
TTcriteria.png [ 36.77 KiB | Viewed 1776 times ]

The Result NOT sorted by date:
Attachment:
TTsort.png
TTsort.png [ 25.61 KiB | Viewed 1776 times ]


Top
 Profile  
 
PostPosted: Mon Mar 21, 2016 9:30 pm 
Offline

Joined: Wed Oct 17, 2012 4:48 pm
Posts: 108
Do you need any more information?


Top
 Profile  
 
PostPosted: Tue Mar 22, 2016 7:12 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7230
Please upgrade to the latest version of TimeTrex and try it again.


Top
 Profile  
 
PostPosted: Wed Mar 23, 2016 3:44 pm 
Offline

Joined: Wed Oct 17, 2012 4:48 pm
Posts: 108
We just upgraded to 9.0.9. No change. The report is still sorting incorrectly.


Top
 Profile  
 
PostPosted: Tue Apr 05, 2016 4:00 pm 
Offline

Joined: Wed Oct 17, 2012 4:48 pm
Posts: 108
Is there anything else we can try?


Top
 Profile  
 
PostPosted: Tue Apr 05, 2016 4:39 pm 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7230
This issue will be resolved in the next version of TimeTrex, due out shortly.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron


Time and Attendance




Powered by phpBB® Forum Software © phpBB Group