AnsweredAssumed Answered

Importing XML data via a server-side script imports dates in wrong date format

Question asked by DamonCasey on Nov 22, 2010
Latest reply on Jul 12, 2011 by John2710

Summary

Importing XML data via a server-side script imports dates in wrong date format

Product

FileMaker Server

Version

FileMaker Server 11 Advanced

Operating system version

Mac OS X 10.6.4

Description of the issue

Importing XML via a server-side script with dates entered as UK format dates (dd/mm/yyyy) and the computer set to UK date format ends with some dates in US format.

Steps to reproduce the problem

Import the following dates from an XML file using a server-side script:

01/12/2010 (1st Dec)

09/12/2010 (9th Jan)

30/12/2010 (30th Dec)

Expected result

All imported dates to be in UK format.

01/12/2010 (1st Dec)

09/12/2010 (9th Jan)

30/12/2010 (30th Dec)

Actual result

01/12/2010 (1st Dec) imports as 12/01/2010 (12th Jan)

09/12/2010 (9th Jan) imports as 12/09/2010 (12th Sept)

30/12/2010 (30th Dec) imports as 30/12/2010 (30th Dec)

The issue doesn't consistently import US dates. Days starting 1-12 import as US dates, days greater than 12 import as UK dates.

Workaround

The script imports dates into a text field and sets the date field to the text field's value.

Importing XML with FileMaker Pro 11 doesn't have this issue, all dates import in UK format.

Outcomes