Date range search does not work in foreign key scenario with database fields

SYMPTOMS

Date range search does not give any results when used in a foreign key scenario with database fields. When adding a date field in the index, stored in a database table/view, only an 'on date' search will give results. Any other combinations such as; between, after or before, will not give any results.

CAUSE

The date column in the underlying database table/view is not of a 'date' type but configured as a 'string' type (varchar).

RESOLUTION

Make sure the date column in the database table/view is of type 'date' or 'date/time' and not a string (e.g. varchar) type.

APPLIES TO

6.3; 6.4; 6.4 Service Pack 1; 6.5