0 Replies Latest reply on Mar 4, 2013 3:30 AM by opotoc

    FMSA 12.02 XML timestamp format broken: MM HH:mm:ss DD/YYYY

    opotoc

      Hi guys,

       

      XML Webpublishing returns for a timestamp field an odd (=unusable) format:

      MM HH:mm:ss DD/YYYY.

      I have no clue how this happens and how I could change this.

      The server runs on German MAC OS 10.6.8 and the files have a German date/time format.

      On FMS 11 everything worked fine.

       

      Any pointers appreciated.

       

      <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

      <ERRORCODE>0</ERRORCODE>

      <PRODUCT BUILD="03/15/2012" NAME="FileMaker Web Publishing Engine" VERSION="12.0.1.150" />

      <DATABASE DATEFORMAT="MM/dd/yyyy" LAYOUT="get.titelversion.resp" NAME="connect" RECORDS="122762" TIMEFORMAT="HH:mm:ss" />

      <METADATA>

      ...

      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="_de" TYPE="TIMESTAMP" />

      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="_da" TYPE="TIMESTAMP" />

      ..

      <COL>

      <DATA>12 09:07:01.10.2012</DATA> // = MM HH:mm:ss DD/YYYY

      </COL>

      <COL>

      <DATA>12 06:20:36.11.2012</DATA> // = MM HH:mm:ss DD/YYYY

      </COL>

       

      Best,

      Alexander