AnsweredAssumed Answered

Dates importing incorrectly

Question asked by TomosHillman on Mar 25, 2015
Latest reply on Mar 25, 2015 by philmodjunk


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?