[rt-users] Dynamic/Relative Date Searching

[Roland, Ryan M]

Well, taking Ken and Russell's lead, I did a little more research and,
finding how useful this was, figured that it would be handy to have this in
the Searching section of the wiki:

http://wiki.bestpractical.com/index.cgi?ManualUsingWebInterface

Scan that and if anyone has anything that should be added or feels should be
removed, please do so.

Thanks,




Ryan Roland

Application Developer
Information Technology
Division of Recreational Sports
Indiana University



-----Original Message-----
From: Kenneth Marshall [mailto:ktm at it.is.rice.edu] 
Sent: Friday, February 25, 2005 10:26
To: Roland, Ryan M
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Dynamic/Relative Date Searching

On Fri, Feb 25, 2005 at 10:13:30AM -0500, Roland, Ryan M wrote:
> We have the need to create a search that uses relative dates.  Say I want
a
> search that will show me all work completed in the last month.  If I
select
> 'Resolved'->'After' I then have to manually enter a date from a month ago
in
> order to get that result.  Then, if I want to bookmark that search result,
> it becomes outdated almost immediately.  Basically what we're looking for
is
> something that would allow us to create searches like:
> 
> Created - After Last Month

Created - After - "-1 month"

> Resolved - After Last Week

Resolve - After - "-1 week"

> Due - Before Next Week

Due - Before - "+1 week"

> Starts - Before Next Month

Starts - Before - "+1 month"

Ken

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3030 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050225/3f41d88a/attachment.bin>