From 5b68f9aaee37dda6f61bb980fe8f6d5b91bc1542 Mon Sep 17 00:00:00 2001 From: mark Date: Mon, 31 Jan 2011 23:59:16 +0000 Subject: [PATCH] search for 'last month', RT#11057 --- rt/lib/RT/Tickets_Overlay.pm | 14 ++++++++++++-- 1 file 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; -- 2.11.0