4 Replies Latest reply on Oct 31, 2014 4:17 AM by PhilipLawton

    Bug with Find Operators "less than"

    PhilipLawton

      Title

      Bug with Find Operators "less than"

      Post

      When using the "less than" (<) operator in Find, I get some odd results.

      e.g. omit <1000 still includes 500 and 250 etc.

      but omit <500 removes 1000, 10000 etc.

      I think that the number ordering is weird, and it calculates 1 is less than 5, regardless of how many zeroes come afterwards. Has anyone encountered similar problems, or a fix?

      I'm using FileMaker Pro 11 Advanced 11.0v1 on a Mac.

      Many thanks, Philip