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: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
