Problems with date field

HCL Domino Domino Forum
1

Hi, we have a database with some fields of date/time type, and it is full_text indexed.When we are going to search for these fields sometimes the documents are not found.

For example, there is a document with a field Start_date of type date/time with value 14/05/2004.

When we search in View ‘untitled’:

field Start_date = 14/05/2004

it does not find any document, but when we search

field Start_date>13/05/2004

then it finds one document.

Also, when we modify some field of that document and save it, the search is ok for

field Start_date = 14/05/2004.

We have tried delete and recreate the index but the problem is continued.

Could you help us?

Thank you.

2

Subject: Problems with date field

Time zones???You might check how the server and the client(s) are configured to use time zones.

3

Subject: RE: Problems with date field

notes.ini has Timezone=-1 for server and client.

4

Subject: RE: Problems with date field

It is not enough to look in NOTES.INI. You can use the free tool here to make a complete check.Also look at the stored value in the document properties. Is there really only a date, like 14/05/2004, or is there also a time and a zone, like 14/05/2004 00:00:00 CDT ? Make this check before you edit the document, and also after you edit the document – does the stored value change?

5

Subject: RE: Problems with date field

I have seen several documents and date/time field has got different values. For example:03/05/2004 00:00:00 CEDT

04/05/2004

03/06/2004 00:00:00 CET

That information is modified by users by Internet.

How can I define this field for only date?

Thanks.

6

Subject: RE: Problems with date field

03/06/2004 00:00:00 CET is probably wrong. June is summer in Europe, so it should be CEDT. The machine that saved this value has bad settings if it is in Europe (but perhaps OK if it is in North Africa).You can use an agent to remove the time and the zone:

FIELD MyField := @Date(MyField);

or in LotusScript:

Evaluate {FIELD MyField := @Date(MyField); “”}, doc

This might cause problems if your application is international and you need to keep the zone.

I think it is still important to be sure that the settings are correct in Notes and Domino.

7

Subject: RE: Problems with date field

Web server settings are the following:

Web User Preferences

Store Web user preferences in cookies: Multi-server

Default regional locale:Browser’s accept-language

If I change default regional locale to server locale, could I solve that problem??

Thanks Rod.

8

Subject: RE: Problems with date field

You real problem is with search. I do not know how these settings affect the search or the full-text index, so I cannot help you. I think it is worth a try.