[rt-users] Relative Dates in Search

[Cassandra Phillips-Sears]

Hi Stephen. I use some dashboard searches that work like this. I  
usually calculate my searches from the ticket's due date, but you  
could use the "started" date or "created" or any other date you wanted.

To see things that are due today and were due any time in the past, I  
use the following string in my search after setting other criteria:

AND ( Due = 'today' OR Due < 'today')

I also have another search that shows me things that aren't due yet:

AND Due > 'today'

If you are looking for more relative dates, I played around with this  
format for a few minutes and it seemed to work:

AND (  Due < 'today' AND Due > 'last week' )

Let me know if it works for you.

It looks like you can get it down to 1 week in either direction, but I  
don't know how it would be adapted to show something like "two weeks  
ago" or "the week before last week," though. I tried putting those  
phrases in the strings and the query didn't return what I wanted.
--
Cassandra Phillips-Sears

Office Manager
Best Practical Solutions, LLC
http://www.bestpractical.com

On Feb 26, 2009, at 11:17 AM 2/26/09, Stephen Cochran wrote:

>
> Is there a way to specific a relative date in a search so that when  
> saved it will calculate off the current date? For example tickets  
> from the past two weeks but without having to adjust the date in the  
> search?
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com