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???