Can't perform Find in all date fields
I'm using FMP10 Advanced on OS 10.6.4 I have a single database that contains four date fields that are identical in every respect with the exception of the field name. I can perform both a normal and advanced Find on only two of the fields. The other two always return "No records match this set of find requests" The fields are all indexed, always validated and only allow 4-digit year dates and display as edit boxes. Manipulating these criteria do not alter the results. I can cut and paste the search criteria between a field that works and one that doesn't so this isn't a typo. Any ideas?