[rt-users] date in search result not correct

Menno Alkemade malkemad at sapienzaconsulting.com
Thu Oct 5 03:52:40 EDT 2006


On Wed, 4 Oct 2006 12:00:24 -0400 (EDT), der Mouse wrote
> > - If i search for "created >= 03/10/2006" i get the tickets created
> >   on 02/10/2006
> > - If i search for "created >= 03/10/2006 00:01" i get the tickets
> >   created on 02/10/2006
> > - If i search for "created >= 03/10/2006 24:00" i get the tickets
> >   created on 03/10/2006
> 
> Just a guess, but could this be a timezone issue?
> 
> If (for example) you're five hours from UTC, does a search for
> tickets >= some day return all tickets for the day before, or only
> tickets in the last five hours of the day before?
> 
> /~\ The ASCII				der Mouse
> \ / Ribbon Campaign
>  X  Against HTML	       mouse at rodents.montreal.qc.ca
> / \ Email!	     7D C8 61 52 5D E7 2D 39  4E F1 31 3E E8 B3 27 4B
> _______________________________________________

It seems you are right it's a timezone issue, but when i do 

"= date"        gives all tickets from date -1 day and not date -1 hour
"> date"        gives all tickets from date
"= date 01:00"  gives all tickets from date

btw server is in BST (british standard time) and client in CET. All timezones
seem to be configured correctly on the server, in RT and on the client.

Menno Alkemade 

Sapienza Consulting LTD



More information about the rt-users mailing list