AnsweredAssumed Answered

XML-Webpublishing timestamp format broken: MM HH:mm:ss/DD/YYYY

Question asked by opotoc_1 on Mar 5, 2013

Summary

XML-Webpublishing timestamp format broken: MM HH:mm:ss/DD/YYYY

Product

FileMaker Server

Version

12.02

Operating system version

10.7.3/10.6.8

Description of the issue

XML Webpublishing returns for a timestamp field an odd (=unusable) format:
MM HH:mm:ss DD/YYYY.
The files have a German date/time format.
On FMS 11 everything worked fine.


          0
         
         

...


..

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


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

Steps to reproduce the problem

Query XML-Webpublishing, include a timestamp field in output

Expected result

12/31/2012 06:20:36  // =  MM/DD/YYYY HH:mm:ss

Actual result

12 06:20:36.31.2012  // =  MM HH:mm:ss DD/YYYY

Outcomes