AnsweredAssumed Answered

Xml query getting different date format

Question asked by PeterWeir on May 10, 2011
Latest reply on May 10, 2011 by philmodjunk

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>

Outcomes