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
