Mohammad,
02/02/2006.xls is not a legal filename, Windows will not accept it! A file name can NOT include all characters, / is one of these illegal characters. / is used to separate subdirectories.
>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
>>
