summaryrefslogtreecommitdiff
path: root/httemplate
diff options
context:
space:
mode:
Diffstat (limited to 'httemplate')
-rwxr-xr-xhttemplate/search/report_receivables.cgi8
1 files changed, 4 insertions, 4 deletions
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi
index 425fa2b89..e68eb8229 100755
--- a/httemplate/search/report_receivables.cgi
+++ b/httemplate/search/report_receivables.cgi
@@ -82,13 +82,13 @@ sub owed {
#handle start and end ranges
+ my $str2time = str2time;
+
#24h * 60m * 60s
- push @where, "cust_bill._date <= extract(epoch from now())-".
- ($start * 86400)
+ push @where, "cust_bill._date <= $str2time now() ) - ". ($start * 86400)
if $start;
- push @where, "cust_bill._date > extract(epoch from now()) - ".
- ($end * 86400)
+ push @where, "cust_bill._date > $str2time now() ) - ". ($end * 86400)
if $end;
#handle 'cust' option