[rt-users] date in search result not correct

[Ruslan Zakirov]

Try 3.4.6rc2 we just released, it has fix for "date =".

On 10/5/06, Menno Alkemade <malkemad at sapienzaconsulting.com> wrote:
> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.