hi all,

any idea help

i try via code under to convert myDBF.file to excel sheet it works but i have field as date 01/01/2005
after convert i see it as 01-Jan-05 i need it as it is 01/01/2005

USE table1
gcDelimName = ALIAS( ) + '.xls'
gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
IF EMPTY(gcDelimFile)  
   CANCEL
ENDIF
COPY TO (gcDelimFile) XLS  

thanks