Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 539
NAME="Employees.fmp12" RECORDS="23" TIMEFORMAT="hh:mm:ss"/>
<METADATA>
<FIELD EMPTYOK="NO" MAXREPEAT="1" NAME="First Name" TYPE="TEXT"/>
<FIELD EMPTYOK="NO" MAXREPEAT="1" NAME="Last Name" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Department" TYPE="TEXT"/>
</METADATA>
<RESULTSET FOUND="2">
<ROW MODID="47" RECORDID="34">
<COL>
<DATA>Joe</DATA>
</COL>
<COL>
<DATA>Smith</DATA>
</COL>
<COL>
<DATA>Engineering</DATA>
</COL>
</ROW>
<ROW MODID="89" RECORDID="78">
<COL>
<DATA>Susan</DATA>
</COL>
<COL>
<DATA>Jones</DATA>
</COL>
<COL>
<DATA>Marketing</DATA>
</COL>
</ROW>
</RESULTSET>
</FMPXMLRESULT>
Importing and exporting dates
Dates are often formatted with two-digit years, such as “12/10/14” instead of “12/10/2014.” To
ensure the accuracy of data, FileMaker strongly recommends that you always
import and export
data using four-digit year dates whenever possible.
Importing dates with two-digit years
When you import date information into FileMaker Pro date fields, any dates that contain two-digit
years will be converted into four-digit years based on the interpretation algorithm described in
Conversion of dates with two-digit years. Because this interpretation process may not convert the
dates to the century you want, you should carefully review any two-digit year date data that you
import. When possible, import only four-digit year dates into FileMaker
Pro.
Exporting dates
When you export FileMaker Pro data, some file formats support the Apply current layout’s data
formatting to exported data option, which allows you to export date, time, and numeric data using
the formats displayed on the current layout. If you use this option and if date fields are formatted to
display only two-digit years, then your exported file will also contain two-digit year dates. Two-digit
year dates can cause accuracy problems when you use the data with other applications. Clear the