diff options
| author | C.J. Adams-Collier <cjac@colliertech.org> | 2014-09-05 10:17:16 -0700 |
|---|---|---|
| committer | C.J. Adams-Collier <cjac@colliertech.org> | 2014-09-05 10:19:04 -0700 |
| commit | f3145308f69d7d3d42af6132439cff26b4fc9008 (patch) | |
| tree | 730d6314b954c5713dd2eb92cf9fbc63cf1b6716 /httemplate | |
| parent | 42fd3cde3a01c5ae6e70c50d4487f36141a2adc3 (diff) | |
FS RT #884; correcting date comparison logic for signup by date report
Diffstat (limited to 'httemplate')
| -rw-r--r-- | httemplate/graph/signupdate.cgi | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/httemplate/graph/signupdate.cgi b/httemplate/graph/signupdate.cgi index 23e459664..011817c3a 100644 --- a/httemplate/graph/signupdate.cgi +++ b/httemplate/graph/signupdate.cgi @@ -40,13 +40,13 @@ my $sdate = DateTime->new( my $edate = DateTime->new( year => $cgi->param('end_year'), - month => ($cgi->param('end_month') % 12 + 1) # first day of the next month -)->epoch(); + month => $cgi->param('end_month') +)->add( months => 1 )->epoch(); my $where .= " AND signupdate >= $sdate ". - " AND signupdate <= $edate "; + " AND signupdate < $edate "; -foreach my $cust (qsearch({ table => 'cust_main', +foreach my $cust (qsearch({ table => 'cust_main', hashref => \%where, extra_sql => $where } )) { next if !$cust->signupdate; |