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?
You might need to import the data into a text field and set up an auto-enter calculation on your date field that auto-enters the correct date from the imported text. This can even be a text field with global storage as I learned from another forum participant several years ago...