[rt-users] SearchBuilder and time intervals

Brian Gallew geek+rt at cmu.edu
Thu May 29 01:35:30 EDT 2008

I'm having a problem doing time interval searches in RT.  What I want is
Owner = '11510' AND
Resolved > datesub(curdate(), interval 2 weeks)

The above syntax works for MySQL (which is what I'm using). 
Unfortunately, SearchBuilder doesn't seem to do the right thing with 
this.  I've also not found a way to get this to work from the 
documentation.  Have I missed something or is this simply impossible?

More information about the rt-users mailing list