search for 'last month', RT#11057

1 files changed, 12 insertions, 2 deletions

diff --git a/rt/lib/RT/Tickets_Overlay.pm b/rt/lib/RT/Tickets_Overlay.pm
index e3658fee6..16e98aec8 100644
--- a/rt/lib/RT/Tickets_Overlay.pm
+++ b/rt/lib/RT/Tickets_Overlay.pm
@@ -539,16 +539,26 @@ sub _DateFieldLimit {
         # if we're specifying =, that means we want everything on a
         # particular single day.  in the database, we need to check for >
         # and < the edges of that day.
+        #
+        # Except if the value is 'this month' or 'last month', check 
+        # > and < the edges of the month.
        
         my ($daystart, $dayend);
         if ( lc($value) eq 'this month' ) { 
-            # special case: > and < the edges of this month
             $date->SetToNow;
-            $date->SetToStart('month');
+            $date->SetToStart('month', Timezone => 'server');
             $daystart = $date->ISO;
             $date->AddMonth;
             $dayend = $date->ISO;
         }
+        elsif ( lc($value) eq 'last month' ) {
+            $date->SetToNow;
+            $date->SetToStart('month', Timezone => 'server');
+            $dayend = $date->ISO;
+            $date->AddDays(-1);
+            $date->SetToStart('month', Timezone => 'server');
+            $daystart = $date->ISO;
+        }
         else {
             $date->SetToMidnight( Timezone => 'server' );
             $daystart = $date->ISO;