[rt-users] Query builder date searches bug or ist my system?

[Olivier Horec]

Hi,

I sent an e-mail about this a few days ago (Problem with Searches). I
have exactly the same problem.
I'm runing on rt-3.4.2 with apache v1.27, mod_perl v1.29 and
DBIx::SearchBuilder v1.27.

Can some body help us,

Thanks in Advance,

Olivier

2005/7/21, Raed El - Hames <r at elhames.co.uk>:
> Hi there;
> 
> My system: rt-3.2.3 (I know I need to upgrade 3.4, I'll be doing that in a
> couple of months)
> Perl v5.8.6 under linux ,DBIx::SearchBuilder v1.26;mod_perl v1.999020;Mysql
> 4.12 and apache2
> I have a strange problem in Query builder, when searching on Created ,
> Lastupdated or any date related search, if for example I need tickets
> created on  20/07/2005, the results I get are tickets created on 19/07/2005
> ... if I query tickets created today I get the correct results
> Tailing rt.log I see that the query going in is correct 'Created =
> 20/07/2005', the time stamps in the ticket display and Tickets table are
> corrects, both RT and the system (Gentoo) are set to BST ...
> Has anyone else had a similar problem, I searched the mailing list and did
> not find anything ?
> Any suggestions of how to tackle this?
> 
> Many thanks;
> 
> Roy
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>