7 Replies Latest reply on Jul 12, 2011 9:07 AM by John2710

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

    DamonCasey

      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.