Is the field in question defined as a Date type field? Sincerely, Chris Kubica President, Founder Application Architects
[email protected] http://www.applicationarch.com http://www.twitter.com/chriskubica 1-919-259-8023 (iPhone) 1-888-896-4608 (Ph/Fax) 1-202-280-2042 (Int'l Ph/Fax) On May 13, 2011, at 4:05 PM, Bruce Button wrote: > Tim > > Thanks for your suggestion. I did change the system format before using a > format like 4/14/2011. > > I did try rebuilding the index but that also doesn't help. > > I must say I am puzzled. The documented search formats are very handy, but I > can't get them to work! > > Bruce > > > On 13/5/2011 11:04 AM, Tim Mansour wrote: >> >> On 13 May 2011 16:47, Bruce Button <[email protected]> wrote: >>> but if I enter anything with a greater than or less than operator (like >>> <4/14/2011) FMP tells me that the find criteria are invalid. >> Bruce you mentioned that your system format is d/m/y; if that is the >> format for the FM file then it's true that "4/14/2011" is not a valid >> criterion. >> >> Other than that: have you tried rebuilding the index of the field >> you're searching? >>
