[rt-users] Searches with variable dates

Rick Russell rickr at rice.edu
Wed May 11 22:05:15 EDT 2005



Lee W wrote:
> All calls where status=open and lastupdates <= 2 days ago (or maybe
> TODAY-2). or are the searches limited to fixed dates.

All date references go through the ParseDate PERL library, documented here:

http://search.cpan.org/~muir/Time-modules-2003.1126/lib/Time/ParseDate.pm

Yes, you can use formalisms like:

  Created > "-3 days"

      created more than 3 days ago

  Due < "+2 days" AND
  Due > "now"

      due date between now and 2 days from now

You can also use these date formats when you change the dates on an RT
ticket; e.g. if you enter the Due Date as "+10 days", it will set the due
date to 10 days from now.

Rick R.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050511/9460a1a7/attachment.sig>


More information about the rt-users mailing list