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

[Thomas Sibley]

On 08/24/2012 09:35 AM, Robert Blackwell wrote:
> For example I would expect these to return the same tickets but they don't:
> 
> This returns 7 tickets.
> Status != 'resolved' AND CF.{FollowUp} < '2012-08-25'
> 
> This returns 513.
> Status != 'resolved' AND CF.{FollowUp} < 'tomorrow'

Capture the SQL that gets run for those queries, and we can see the
difference between parsing.  It _shouldn't_ be different, but I'm
guessing an implicit time part might be sneaking in.