Hi
I want to export the invoice no and invoice date to the Excel worksheet,
I set the date to british, the date format is dd-mmm-yyyy,
the record of the invoice date format in the invoice.dbf is store in mm/dd/yy,
I find that if the invoice date in invoice file is 5/24/14, the output of the cell is in 24-May-2014, it is dd-mmm-yyyy correct format ,
but if the invoice date in invoice file is 5/7/14, the output of the cell is still is 05-Jul-2014, I think it should be 07-May-2014.(dd-mm-yyyy)
why it change ?
Please advise.

SET DATE BRITISH
oExcel = CREATEOBJECT([Excel.Application])
oExcel.SheetsInNewWorkbook = 4
oWorkbook = oExcel.Workbooks.Add()
nrow=2
select invoice
do while !eof()
    with oExcel.activesheet
         .Range("A"+TRIM(PADR(nrow,11))).value="'"+dtoc(invoice->invno)
         .Range("B"+TRIM(PADR(nrow,11))).NumberFormatLocal ="dd-mmm-yyyy"	    
         .Range("B"+TRIM(PADR(nrow,11))).value=dtoc(invoice->invdate)
   endwith 
   nrow = nrow + 1
   select invoice
   skip 1
enddo

Thanks.
Derek