opotoc

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

Discussion created by opotoc on Mar 4, 2013

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

Outcomes