1 Reply Latest reply on May 10, 2011 3:01 PM by philmodjunk

    Xml query getting different date format

    PeterWeir

      Title

      Xml query getting different date format

      Your post

      Hope someone can help we are converting from FM6 to FM11. We use a lot of php scripts via fx.php so access the data via xml.

      We have converted the files and the scripts still work but when doing a search if we enter the date as 03/01/11 (3rd Jan) it is finding records for ist march.

      Looking at the client app the date format is correct and the find works fine.

      Is there some sort of setting on the server console to set the date format.

      my url is /fmi/xml/FMPXMLRESULT.xml?-db=BK&-lay=ROBERT&-max=all&Entry+Date.op=eq&Entry+Date=03%2F01%2F2011&-find

      In FM6 this would return 3rd jan records but in FM11 it is returning 1st march

      Many thanks

      Just had more of a look and the FM11 xml return

      <FMPXMLRESULT><ERRORCODE>0</ERRORCODE><PRODUCT BUILD="03/02/2011" NAME="FileMaker Web Publishing Engine" VERSION="11.0.3.302"/><DATABASE DATEFORMAT="MM/dd/yyyy" LAYOUT="ROBERT" NAME="BK" RECORDS="353950" TIMEFORMAT="HH:mm:ss"/><METADATA>

      But the FM6 return

      <FMPXMLRESULT><ERRORCODE>0</ERRORCODE><PRODUCT BUILD="5/4/2002" NAME="FileMaker Pro Web Companion" VERSION="6.0v1"/><DATABASE DATEFORMAT="d/M/yyyy" LAYOUT="ROBERT" NAME="BK.fp5" RECORDS="355432" TIMEFORMAT="k:mm:ss"/><METADATA>