AnsweredAssumed Answered

date range xml find query in filemaker server 12 error 500

Question asked by timgardner on Apr 10, 2013
Latest reply on Apr 15, 2013 by disabled_Ed-Case

Title

date range xml find query in filemaker server 12 error 500

Your post

      

     I'm hitting a showstopping issue running a date range query in a server upgrade from 9 to 12.  
      
     On two different FMS 12 server installations I get the same result, mac mountain lion and windows 2003 server.
      
     Using the sample database, the following query gets a 500 error ("Date value does not meet validation entry options").:
      
      
     <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
     <ERRORCODE>500</ERRORCODE>
     <PRODUCT BUILD="06/21/2012" NAME="FileMaker Web Publishing Engine" VERSION="12.0.2.228"/>
     <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="0" TIMEFORMAT=""/>
     <METADATA/>
     <RESULTSET FOUND="0"/>
     </FMPXMLRESULT>
      
     The same syntax used to work in FMS 9.
      
     Since I'm using this type of query to sync databases, I need a way to query on a date range in order to upgrade to 12.
      
     Thanks,
     Tim
      

Outcomes