[rt-users] Query for Created 'Last Month'?

[Ruslan Zakirov]

ok, then http://search.cpan.org/dist/Time-modules/lib/Time/ParseDate.pm
needs patching.

On Thu, Jul 3, 2008 at 5:17 PM, Jean-Sebastien Morisset
<jsmoriss at mvlan.net> wrote:
> On Thu, Jul 03, 2008 at 05:14:07PM +0400, Ruslan Zakirov wrote:
>> Created > 'Last Month'
>
> Ruslan,
>
> Thanks, but that gives me this month too. :-) I tried the following,
> just in case, but it doesn't work...
>
>    Created > 'Last Month' AND Created < 'This Month'
>
> js.
>
>> On Thu, Jul 3, 2008 at 4:34 PM, Jean-Sebastien Morisset
>> <jsmoriss at mvlan.net> wrote:
>>> Hi everyone,
>>>
>>> I'm not very good with SQL queries, so I'm having trouble constructing
>>> a URL like this to select all tickets from last month...
>>>
>>> http://rt.me.org/Search/Results.tsv?Order=DESC%7CDESC%7CDESC%7CASC&Query=%20Created%20%3E%20'2008-06-01'%20AND%20Created%20%3C%20'2008-06-30'&...etc...
>>>
>>> It would be nice if "Created = 'Last Month'" would work, but of course,
>>> it doesn't. :-) Any ideas?
>>>
>>> js.
>
> --
> Jean-Sebastien Morisset, Sr. UNIX Administrator <jsmoriss at mvlan.net>
>



-- 
Best regards, Ruslan.