Internally, date fields are the number of days since Jan 1, 1900.
There is a default format and this is what is exported.
Home > Designing and creating databases > Editing objects on layouts > Formatting and setting up field objects in Layout mode > Specifying formats for date fieldsSpecifying formats for date fieldsYou can control how FileMaker Pro displays the values in date fields and calculation fields with date results.To specify formats for date fields:1.In, select one or more date fields or calculation fields with a date result.For more information, see Selecting objects.3.
To display datesDo thisExactly as enteredSelect As entered.In a predefined formatChoose a format.To change the separator between parts of a numeric date, for Numeric separator, type another character.In a custom formatSelect Custom and choose options and separator characters for day of week, month, day of month, and year.With leading zeros (as in
01/02/99) or leading spaces in numeric parts of datesIn the Leading character area, choose <None>, Zero, Space for For day numbers, For month numbers, or both. (This option is not available if you've chosen As entered.)With different text formattingSelect text options using the Appearance tab of the Inspector. For more information, see Specifying text formats for fields.Using a different Japanese date display (if you’re using a font that contains Japanese characters)In the Japanese area, for Numeral type, choose a display type.4.Press Enter or Tab, or click outside the Inspector to apply the changes.Important No matter how you format a date field in Layout mode, whenever you click or tab into the field in Browse mode, FileMaker Pro displays the date with a four-digit year. FileMaker recommends that you always enter dates with four-digit years. If you enter dates with two-digit years, they are converted to four-digit year dates as described in Conversion of dates with two-digit years.Notes•When As entered is selected, FileMaker Pro will display dates with four-digit years, even if you originally entered the dates with two-digit years. Use the Custom option or one of the two-digit year options on the Format list described above to display dates with two-digit years.•Be sure to size the date field on the layout according to the format you choose. For example, the date Monday, May 5, 2010 needs more room than 5/5/10. For more information, see Resizing and reshaping objects.•To format a date symbol (which displays the current date), select the symbol “//” (two slashes) in Layout mode, and then use the Data Formatting area of the Inspector to format it as you would a date field as described above. For more information about the date symbol, see Inserting the date, page number, or other variable onto a layout.•To make it easier to enter dates in a field in Browse mode, you can set up the field to display a.•For more information about defining date fields, see Defining date fields.
When exporting records, there's an option to "use current layout's data formatting when exporting". So if you use that option with a layout that specifies the desired date format, you should get the result that you need.
You're a star!! Works perfectly :)