[rt-users] Search Custom Field relative to today

[Ryan Hardester]

I got it working, since it was going to be on the command line anyway, I
just used the shell to generate today's date.

--Ryan

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Ryan
Hardester
Sent: Wednesday, September 20, 2006 11:50 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Search Custom Field relative to today

I am working on a sort of people tracking queue. Where in the ticket in
that queue CF's say that i will be out 2006-08-19 (CF1) to 2006-08-26
(CF2) they are required to input date formatted values. In the search
builder I have been able to select the specific queue, and then I see
the 2 custom fields in the search options. Is there a variable i can use
that will test to see if CF1 is equal to or before today's date and CF2
is still after today. I'd like to be able to use the crontool to run
this search then send out an e-mail out in the morning that would say
"Ryan will be out today" for the duration of my leave.

Or am i going about it all wrong. I got my book tonight, and am coming
up with all kinds of ideas. heh

--Ryan
_______________________________________________
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