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

[Robert Blackwell]

Hello,

We have a global custom field of Type 'select date' (not datetime)
called FollowUp.

When trying to query tickets using the Advanced tab and TicketSQL
using the word 'today' as described on this page,
http://requesttracker.wikia.com/wiki/TicketSQL, we are not getting the
same results as explicitly searching with today's date.

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'

We are using RT 4.0.5.

Suggestions welcomed.

Is there a better place to learn about TicketSQL?

Thank you
Robert