7 Replies Latest reply on May 10, 2014 2:43 AM by lijnbach

    Find "from - until" not working properly when using "-" as separator in field

    lijnbach

      Summary

      Find "from - until" not working properly when using "-" as separator in field

      Product

      FileMaker Pro

      Version

      13.0v3

      Operating system version

      Mac OSX as well as Windows 7

      Description of the issue

      I have a field with a separator. The field contains text values like "01-AA". If a find "from - until" is performed, the find result always loses the first in row.

      So if I go to find and type "01-AA..02BB", the result is only "02-BB". If I type "01-AA..ZZ-99" I get them all, except 01-AA.

      I found out that is only the case if the separator "-" is used.

      See forum post:
      http://forums.filemaker.com/posts/9c4ef820c7

      Steps to reproduce the problem

      See above

      Expected result

      Result should be "01-AA until 02-BB"

      Actual result

      02-BB

      Exact text of any error message(s) that appear

      No error messages

      Workaround

      Not yet a good one.