1 Reply Latest reply on Mar 25, 2015 10:32 AM by philmodjunk

    Dates importing incorrectly



      Dates importing incorrectly


      I have inherited a filemaker based workflow which involves imports and exports biographic data in XML formats.

      The importing file specifies a "D/m/yyyy" format, yet the dates are being stored in the system (and therefore the output) as 'mm/dd/yyyy' - except not consistently, filemaker can spot dates where that would be invalid and is changing some values but not others.

      For instance, if the input is:

      birth 06/02/1861, death 22/05/1926

      the following is stored in filemaker:

      birth 02/06/1861, death 22/05/1926

      How can I stop this happening and have the dates imported accurately?