Try as I might I cannot get a report that exports orders to dbf format to use the mm/dd/yy format. It consistently exports dates as yyyy/mm/dd. Our warehouse system cannot accept 4 digit years.
Any way to force this? I tried changing the format to mm/dd/yy and setting long years to no but no change.
??

Hello Nancy,

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].

Hi Nancy,

Though Quik Reports can print different date formats, it will not alter the format of the data nor the way it is stored. Thus, you will not be able to export the dates with only 2 digit years in the dbase format. The comma delimited format does export dates as YYMMDD, but this may not be appropiate for your system. Would you be able to edit the dbase format in Excel?

The only thing else you may be able to do is create a formula field that physically extracts only the last 2 digits from the year. This would mean the creation of a text formula with syntax similar to:

ToText(Year(date))[3 to 4] + ToText(Month(date)) + ToText(Day(date))

This being a solution would fully depend on how the target program would interpret this field, and if it could read this as a date.