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

Jean-Sebastien Morisset jsmoriss at mvlan.net
Thu Jul 3 08:34:38 EDT 2008


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>



More information about the rt-users mailing list