AnsweredAssumed Answered

Find is finding too much

Question asked by hoib on Jan 30, 2014
Latest reply on Feb 1, 2014 by philmodjunk


Find is finding too much


     OK, this has bugged me all day and I've got to come for help.

     On a layout, there's a begin_date field.  It is of type "date" and is auto-entered.  Very simple stuff.  The table itself contains 4300+ records.  I want FM to show me -only- records with dates later than 1/1/2012.

     I go to Find Mode, click in my dates field and type this string:  > 1/1/2012, Perform Find.  It finds 1850 records but the dates are not "> 1/1/2012" but extend all the way back to 2003.  I don't understand why FM would present any record before 1/1/2012.  I've read through the Help and followed the syntax pretty carefully.

     Is this because there's a relationship between the TO containing "begin_date" and the TO the layout is based on?  I felt that shouldn't be an issue but maybe it is???