[rt-users] Search Custom Field relative to today

[Ryan Hardester]

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