diff options
| -rw-r--r-- | LedgerSMB/Form.pm | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/LedgerSMB/Form.pm b/LedgerSMB/Form.pm index 6eba7223..13f2f34a 100644 --- a/LedgerSMB/Form.pm +++ b/LedgerSMB/Form.pm @@ -2152,8 +2152,10 @@ sub all_years { # get years my $query = qq| - SELECT (SELECT MIN(transdate) FROM acc_trans), - (SELECT MAX(transdate) FROM acc_trans)|; + SELECT (SELECT transdate FROM acc_trans ORDER BY transdate asc + LIMIT 1), + (SELECT transdate FROM acc_trans ORDER BY transdate desc + LIMIT 1)|; my ( $startdate, $enddate ) = $dbh->selectrow_array($query); |