Service Desk Practitioners Forum
cancel

Problem when searching by registration created field

Highlighted
mg_ITE
Super Contributor.

Problem when searching by registration created field

Hi.. I've problem with searching in HP SD 4.5 sp23..

When I'm searching by field: Registration;Created is yesterday then SD search my data ok.. It shows service calls registered yesterday. But when I'm searching using: Registration;Created on 26-12-2010, I'm getting service calls registered at 25-12-2010.

In attach Ypu can see a example..
3 REPLIES
The Pike
Acclaimed Contributor.

Re: Problem when searching by registration created field

Very interesting. I just ran the same query and get no incorrect results.

Remember all timestamps are stored in the SD database corresponding to UTC, then the client converts the timestamps according to SD and OS regional settings. I'd double-check everything is consistent.

Hope this helps.
Points are welcome.

The Pike
mg_ITE
Super Contributor.

Re: Problem when searching by registration created field

What sp do You have? Maybe there was a problem fixed by some sp greater then 23??
mg_ITE
Super Contributor.

Re: Problem when searching by registration created field

I checked all settings...

Application server, database server (app level and OS level) has the same time zones (in attach).

And when I search service calls by Registration;Created = yesterday , system displays correct data.