mysql me harder

[freeside.git] / httemplate / search / report_receivables.cgi

diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi
index 425fa2b..e68eb82 100755 (executable)
--- 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