Relative date searches against date custom fields

Hi,

Does anyone have any information regarding relative date searches
against RT custom fields?

I have some custom fields that I need to be able to do relative date
searches against. i.e. “AND 'CF.{Expiry} < ‘now + 4 weeks’”

I’ve checked the list, and I can see a few unanswered queries along the
same lines (i.e.

) - but no clear answers

Are relative date searches supported for CF yet? Will they be? Can
anyone suggest a workaround in the meantime? … or maybe they work
just fine and it’s me that’s doing something wrong…

Thanks for any help

Boli
Jon ‘Boli’ Copeland
Network Engineer
IT Sales & Services Ltd
boli@itss.co.tz
+255 (0) 685 374780

Are relative date searches supported for CF yet? Will they be? Can
anyone suggest a workaround in the meantime? … or maybe they work
just fine and it’s me that’s doing something wrong…

Unfortunately relative date searching isn’t supported against
date/datetime CFs yet. There’s an open bug about it (albeit not a very
descriptive one for non-devs) and an in progress branch that needs more
thought and review.

http://issues.bestpractical.com/Ticket/Display.html?id=18281

Thomas