AnsweredAssumed Answered

Bug with Find Operators "less than"

Question asked by PhilipLawton on Sep 24, 2014
Latest reply on Oct 31, 2014 by 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

Outcomes