hi,
i try as under
i got excel sheet name as "main1_19990101"
but i need excel sheet name as 01/01/1999 as the same data at myfield date
USE main1
gcDelimName = ALIAS( ) + '.xls'
gcPath = [c:\]
gcDelimName = gcPath + ALIAS() + "_" + DTOS(date) + ".XLS"
COPY 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
>
