Hi Darren, list,
6 months later. have you found a solution to this problem?
I too would like to have a saved search that filters by current date (or
current week, or some other date range relative to today).
It seems there's no such code in pure RT.
Has anyone developed it for his own RT?
Thanks in advance,
Eynat
From: Darren Ellis [EMAIL PROTECTED]
Sent: Aug 11, 2007, 4:54 AM
To: rt-users@lists.bestpractical.com
Subject: Search Custom Field for Today's Date
Hi All,
I am using RT 3.6.4 on CentOS 5.0. Everything stock seems to be
working fine.
I've defined a few custom fields, one of which I am using as an
appointment date field. I would like to create a saved search called
"Today's Assignments" that automatically searches the date field for
today's date and returns matches.
Googling led me to articles that implied that you could use "TODAY"
or "today" as a search criterion. As yet I am unable to successfully
make this search work.
I have tried the following date formats in the field:
YYYYMMDD (20070811)
MM/DD/YYYY (8/11/2007)
My search criterion line is:
AND 'CF.{Appt. Date} = 'today'
I have also tried:
AND 'CF.{Appt. Date} = 'TODAY'
I looked through my copy of RT Essentials and didn't find the
information I needed there either.
Can anyone help?
Thanks.
Darren
_______________________________________________
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
