3 Replies Latest reply on Sep 3, 2013 7:21 PM by Malcolm

    Upgrade to FMS Breaks Date Searches



      Upgrade to FMS Breaks Date Searches


      FileMaker Server


      Operating system version

      OS X 10.7.5

      Description of the issue

      the old date format I used to use no longer works ie: 09/03/2013

      However, if I specify the date as 09-03-2013 it does work.

      However if I try to specify a search to select all records greater than a date neither >=09/03/2013 or >=09-03-2013 works.

      Steps to reproduce the problem

      Install Filemaker Server 12 v3 on Mac OS X 10.7.5
      Create Web App using XML interface
      Upgrade FMS to 12 v4
      Watch web searches fail

      Expected result

      standard functions should work as advertised

      Actual result

      search fails


      In some cases it is possible to use the hyphen instead of the forward slash but this does not work for range searches.