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.
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.
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
Apply current layout’s data formatting to exported data option in order to export dates in a four-digit year format.