Hi,
Use the 20060202.xls format, as the files will be sorted correctly when you view them in explorer, i.e. easier to find.
The "/" divide character isn't a legal Filename character in DOS or windows, this is very basic stuff, you should know it.

Also have you ever used SET STEP ON (invoke in DEBUGGER) in any of your prgs, it allows you to trace your prg while it is running, and also inspect the contents of all variables, stacks etc. If you use it you will be able to answer a lot of your questions your self.



>hi,
>i try again as under i got 20060202.xls
>
>is ther a way to convertit to 02/02/2006.xls
>

>SET CENTURY on
>USE main1
>gcDelimName = ALIAS() + '.xls'
>gcPath      = [c:\]
>gcDelimName =  gcPath +  DTOS(date) +  ".XLS"
>COPY fields no,date TO (gcDelimName) XL5
>
>

>
>>>hi all,
>>>
>>>
>>>i need help to rename after convert via this code under
>>>excel sheet name as field(date) 14/04/2006
>>>my table have field (date),same date for all records
>>>ex..
>>>

>>>date
>>>----
>>>14/04/2006
>>>------------
>>>

>>>

>>>USE main1
>>>gcDelimName = ALIAS( ) + '.xls'
>>>gcPath      = [\\Jtchp58544\new smd\Training\Quality Test 01\]
>>>gcDelimName =  gcPath + ALIAS() + [.XLS]
>>>COPY fields num,msisdn,date,flag TO (gcDelimName) XL5
>>>

>>>thanks
>>
>>Rename what? The file?
>>

>>*gcDelimName =  gcPath + ALIAS() + "_" + DTOS(DATE()) +  ".XLS"
>>gcDelimName =  gcPath + ALIAS() + "_" + DTOS(DATE(2006,4,14)) +  ".XLS"
>>COPY fields num,msisdn,date,flag TO (gcDelimName) XL5
>>