[rt-users] Searching on TransactionDate > xxx = no results

[Ben Goodwin]

Ever since I upgraded from RT2 to RT3, a search like:

TransactionDate > 2003-10-01 04:00:00 GMT

*always* fails to return anything.  Searching for TransactionDate < xxx
does return stuff though.

I've tried to debug this but I haven't had much luck.  It's hard to grok
the stuff in the mysql SQL log especially with all the high-ascii chars in
the session table.

I've tested on production and in development.  Both RH7.3 systems... I've
even tried moving to a self-compiled Perl 5.8.1  since 7.3 comes with
5.6.1.  The dev environment has all the latest perl modules (as of a
couple hours ago) except searchbuilder which is at 0.88 cuz the newer
versions appear to have issues.

Can someone lend a hand?

MySQL 4.0.14 & .15, RT 3.0.6 (both upgraded and fresh pristine installs),
mod_perl/apache 1.3.28

Thanks,

  -=| Ben