Date in search result not correct

RT Users
1

Hi,

I’m using RT 3.4.5 and i’m having some strange results when i search.

  • 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

Why does “created >= 03/10/2006” give me the results for the day before ?

Thanks in advance

Sapienza Consulting LTD

2

Menno Alkemade wrote:

Hi,

I’m using RT 3.4.5 and i’m having some strange results when i search.

  • 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

Why does “created >= 03/10/2006” give me the results for the day before ?

Thanks in advance

–
Sapienza Consulting LTD

The search doesn’t take the timezone into account.

Jeff Voskamp

3
  • 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@rodents.montreal.qc.ca
/ \ Email! 7D C8 61 52 5D E7 2D 39 4E F1 31 3E E8 B3 27 4B

4
  • 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@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

5

Try 3.4.6rc2 we just released, it has fix for “date =”.On 10/5/06, Menno Alkemade malkemad@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@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.