Hi,

I've noticed that this issue has been raised before but I can't find a satisfactory solution.

I'm doing a "copy to myfile type xls" command from VFP 6. There is a date field in my source file (a cursor in this case). In Excel (Excel 97) the resulting field is not formatted as a date field, but as a text field. Changing it in Excel (using the Format field command) works fine, but sorting on the field sorts it 01/02/67, 01/03/52, 01/04/87, etc.

Any idea if there is a workaround for this? I've tried changing the date within VFP to a different format (such as SET DATE ANSI, result = 1967.02.01), but this makes no difference.