0 Replies Latest reply on Mar 7, 2013 8:57 AM by kalle_samuelsson

    Wrong separator for dates from WPE for swedish date format

    kalle_samuelsson

      Summary

      Wrong separator for dates from WPE for swedish date format

      Product

      FileMaker Server

      Version

      FMSA 12.0.1, FMSA 12.0.2, FMSA 12.0.3, or actually WPE 12.0.1.150

      Operating system version

      Windows 2008 Server Standard Edition SP1, MacOS 10.8.2 Server

      Description of the issue

      WPE returns datefields using a bad format. The separator used is a dash (-) instead of a forwardslash (/) wich makes dates hard to parse.

      PHP function strtotime() fails or returns 1970-01-01.

      Since no issue-reports from english users is present I guess this only affect users who wants swedish date format or uses swedish operating systems?

      Get a demo database here:
      http://www.premium.se/temp/date_issue_fms12.0.3.zip

      Steps to reproduce the problem

      Create a datebase on a swedish platform (or download demo file)

      Add a datefield and som records with dates in them

      Allow XML-publishing for a user

      Open the database on a FileMaker Server

      perform a -findall xml request on a layout where the datefield is present

      Expected result

      A record in the XML result from WPE


         
              03/07/2013
         

      Actual result

      A record in the XML result from WPE


         
              03-07-2013
         




      Notice the DASH instead of SLASH in datefield data tag

      Exact text of any error message(s) that appear

      n/a

      Configuration information

      I guess this must be depending on OS language settings? We use swedish date format which is  YYYY-MM-DD but WPE should return dates in format MM/DD/YYYY and we re-format it to our preference.

      The database must probably also be created in FileMaker running on a swedish OS?

      Workaround

      Use PHP string functions to fix the date or create a calculated field that returns the date as text and then use that field to return trough WPE