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
Comments
0 comments
Article is closed for comments.