[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