>In one customer table, a SELECT is not returning all of the matching information.
>
>The SELECT is based on date. The table is indexed on date.
>
>If there are 10 records with a matching date, the SELECT returns 5 records (you can tell that there are 10 records by issuing a BROWSE). If the customer goes in and types one of the dates over, the SELECT now returns 6 records. If you issue a REPLACE ALL DATE WITH DATE, nothing changes. If you DELETE TAG ALL and INDEX ON etc., nothing changes.
>
>This is not a problem with the date formats, since the dates are filled in programmatically and the SELECT is for date()-1.
>
>Any ideas?
if the table is in a .dbc, re-validate the database.