Paul,

Is the key "pure" date or a string date?

*IF* a string date, maybe some records were created with a different SET DATE format than the others???

good luck,
Jim N

>> >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.
>>
>> if the table is in a .dbc, re-validate the database.
>
>I forgot to mention -- this is FoxPro/Windows, not VFP.