Hi,

I find that when I export some data to a Excel file which have the date field
in the first column, it cannot be sorted by the date field it in Excel.

Why ?

My code as following

use invoice
SELECT invoice
EXPORT TO invenq.xls TYPE XLS FIELDS delidate, invno, stock
oExcel = CREATEOBJECT([Excel.Application])
oWorkbook = oExcel.Workbooks.open("C:\WTS\MID\INVENQ.XLS")
oExcel.Visible = .t.
lnLastRow = oExcel.activesheet.UsedRange.Rows.Count
lnLastCol = oExcel.activesheet.UsedRange.Columns.Count
oExcel.activesheet.Range("A2:A"+TRIM(PADR(lnLastRow,11))).NumberFormat ='dd/mm/yyyy'

where the delidate is a date type field.

But If I manually create a new worksheet and I key in the date field,
then it can be sorted.

Why ? Please advise.
Thanks.
Derek