0 Replies Latest reply on Mar 5, 2013 11:05 PM by opotoc_1

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

    opotoc_1

      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