AnsweredAssumed Answered

Wrong separator for dates from WPE for swedish date format

Question asked by kalle_samuelsson on Mar 7, 2013

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

Outcomes