AnsweredAssumed Answered

Can't perform Find in all date fields

Question asked by KyleWitek on Aug 31, 2010
Latest reply on Aug 31, 2010 by philmodjunk

Title

Can't perform Find in all date fields

Post

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?

Outcomes