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 Apply current layout’s data formatting to exported data option in order to export dates in a four-digit year format.
Related topics 
Formatting and setting up field objects in Layout mode
Specifying formats for date fields
Saving and sending records in other formats
Exporting data from FileMaker Pro