Whenever we create a new document on live system and view search by query like FIELD DateFrom=mm/dd/yyyy, search result is null. But if the same documents I move from live to dev server the search is working well. Field data type is date/type on both systems and full text indexed. What causes this issue. Thanks in adv.
Subject: View Search Query not working
Are the server versions identicalAre the Server OSes the same?
Are the date formats on the server configured the same
Subject: RE: View Search Query not working
Both environments are same, no differences.I noticed in live, when i go to View - More- Field, when i select date field it shows only two options ie contains and does not contains
But in dev system i am getting all other options also.
There could be something i missed
Subject: RE: View Search Query not working
That sounds an awful lot like an UNK table problem on your live database (meaning that the field hasn’t always been date/time, at least not on all documents). A copy-style compact and a new FT index will usually work wonders, provided that there is nothing in the DB that could persuade Notes that the field might not be a date/time field.