[rt-users] Using 'today' in an Advanced search gives different results than using explicit date.

Thomas Sibley trs at bestpractical.com
Thu Sep 6 14:34:10 EDT 2012


On 09/06/2012 07:07 AM, Robert Blackwell wrote:
> Here is the SQL and stack trace of two queries obtained by using
> "Configuration » Tools » SQL Queries".
> 
[snip]
> ObjectCustomFieldValues_1.Content < 'today'

Er, right.  I forgot that date and datetime CFs don't get the same
"natural language" parsing that core datetime fields do.  This is a
known bug, and I believe we have a ticket open about it (but maybe not,
can't find it quickly).

Sorry about that.



More information about the rt-users mailing list