GnuCash
Contact   Instructions
Bug 788332 - Last Reconcile Date column sorts by day of month not date
Summary: Last Reconcile Date column sorts by day of month not date
Status: RESOLVED FIXED
Alias: None
Product: GnuCash
Classification: Unclassified
Component: User Interface General (show other bugs)
Version: 3.2
Hardware: Other Windows
: Normal normal
Target Milestone: ---
Assignee: ui
QA Contact: ui
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-09-29 08:14 EDT by Ian K
Modified: 2018-11-18 05:55 EST (History)
6 users (show)

See Also:


Attachments
reconcile date:wrong order in dd.mm.yyyy format (12.72 KB, image/png)
2018-09-20 04:01 EDT, Gunter Kramp
no flags Details

Description Ian K 2017-09-29 08:14:06 EDT
On the chart of accounts, with "Last Reconcile Date" column selected, sorting by this column sorts by the day of the month not the actual date.
Example 02/08/2017, 03/10/2016, 05/07/2017.
I think this has been happening in a few earlier releases so isn't specific to 2.6.17.
Windows 10 64 bit, Date Format Locale (UK).
Comment 1 Gunter Kramp 2018-09-20 04:01:31 EDT
Created attachment 372983 [details]
reconcile date:wrong order in dd.mm.yyyy format
Comment 2 Gunter Kramp 2018-09-20 04:06:34 EDT
Maybe this has something to do with Bug 793156 ?
It seems to be the same error:
The date is sorted by its string representation and not by Date Value, so the result ist wrong if the Date is not in the YYYY.MM.DD Format.

Don`t know if there is a general Error in all Date sorts because its all implemented in one function or just in some Date sorting Functions

Sorting transactions in an account is correct but may be done by a different code
Comment 3 Gunter Kramp 2018-09-20 04:07:20 EDT
Comment on attachment 372983 [details]
reconcile date:wrong order in dd.mm.yyyy format

Still present in Version 3.1
Comment 4 Gunter Kramp 2018-09-20 04:12:52 EDT
This Bug is not fixed in Version 3.2. just tried it, screenshot would be the same als in 3.1. so i dont add a new one
Comment 5 Bob 2018-10-31 06:30:21 EDT
I have a possible fix for this locally, will add to a PR in due course.
Comment 6 Gunter Kramp 2018-10-31 06:42:49 EDT
Great, I am looking forward to it and will be happy to try it when its in the Repositories (but I am not able to build the Program myself)
Comment 7 Bob 2018-11-04 05:17:18 EST
Added possible fix to PR432.
Comment 8 Geert Janssens 2018-11-18 05:54:34 EST
The fix was accepted and will be included in GnuCash 3.4. Thanks!
Comment 9 Geert Janssens 2018-11-18 05:55:37 EST
@Gunter: as you are on Windows you can already test the fix by downloading and installing a the most recent nightly build from here:
https://code.gnucash.org/builds/win32/maint/

Note You need to log in before you can comment on or make changes to this bug.