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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Hardester Sent: Wednesday, September 20, 2006 11:50 PM To: rt-users@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com