When you export, the date formatting that you set for printing the report is not kept for the exported date field. If you are exporting to a spreadsheet, you can usually format the date fields from within the spreadsheet.

1. If you need to have the date in a specific format in the export file, you will need to use a formula that converts the date to numbers. Then convert the numbers to text fields. This is an example:

(if Month (Date) >= 10 then ToText (Month(Date)) else "0" + ToText (Month(Date))) + "/" + (if Day (Date) >= 10 then ToText (Day(Date)) else "0" + ToText (Day(Date))) + "/" + (ToText (Year(Date)))[3 to 4]

If you want the long year, remove the subscripted [3 to 4].