[rt-users] Search Custom Field for Today's Date

[Eynat Nir Mishor]

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 [darren at mepad.net]
Sent: Aug 11, 2007, 4:54 AM
To: rt-users at 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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080203/cd7d2a89/attachment.htm>