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

[Kenneth Crocker]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100913/5a5b1500/attachment.htm>