Xml query getting different date format
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
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="18.104.22.1682"/><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>
Sounds like this issue: Importing XML data via a server-side script imports dates in wrong date format
This is one of many acknowledged bugs that can be found in the Known Bug List here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: http://www.4shared.com/file/8orL8apk/FMP_Bugs.html