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
> <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
