Paul,

Glad to hear you got around your problem (doesn't sound like it was actually "solved").

My reswponse was *NOT* concerned with the field itself, but rather with its INDEX and when/how it was created.

From what you have described as the "solution", I'm still inclined to feel that it was a 'how/when the index was built for those records' problem *IF* (I repeat: *IF*) the index in question was a character date index.

cheers,
Jim N

>> 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???
>
>The field was filled in with code similar to:
>
>m.CreaDate = date()
>gather memvar memo
>
>ie. it was a 'pure' date, and there was no question about the format or
>it belonging to the right century.
>
>The solution was to copy the data to a temporay table. Delete the table
>in question. Copy the data back to an empty structure. And re-generate
>the indexes.
>
>Thanks for all of the suggestions.
>
>/Paul