[rt-users] Need help with RT-SQL on days calculation

[Kenneth Marshall]

That should also be:

Due > '1 day ago'

and not:

Due > 'today'

Ken

On Mon, Sep 13, 2010 at 12:47:11PM -0500, Kenneth Marshall wrote:
> On Mon, Sep 13, 2010 at 10:38:54AM -0700, Kenneth Crocker wrote:
> > To list,
> > 
> > I've been to the wiki and did some googling but no joy. Most likely my
> > inexperience with both.
> > 
> > I'm trying to run a query in RT that will give me all "open" tickets that
> > are due within the next 30 days. Simple enough, but I can't seem to get the
> > syntax right. I have:
> > 
> > (  Status != 'resolved' AND Status != 'rejected' ) AND Due < (today + 30
> > days). I've tried variations of 'Today' and no joy.
> > 
> > Help please?
> > 
> > Thanks.
> > 
> > Kenn
> > LBNL
> 
> What about something like:
> 
> Due < '30 days from now'
> AND Due > 'today'
> 
> with the additional list of statuses?
> 
> Regards,
> Ken
> 
> RT Training in Washington DC, USA on Oct 25 & 26 2010
> Last one this year -- Learn how to get the most out of RT!
>