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

Thu Jul 3 09:15:51 EDT 2008

On Thu, Jul 03, 2008 at 12:34:38PM +0000, Jean-Sebastien Morisset 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?
> 

 Created > '1 month ago'

;)