X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_receivables.cgi;h=e68eb82291e2e02e39b55292d413136d3a2c01ce;hp=425fa2b89214d1aa7da3399b54f76ccc2aeb8bc8;hb=556cefb34ed648303951009e3bec919e18532bed;hpb=9ed8adbf1ab5aba8181903e9c262f2b69dba6cbc

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