04-14-2010 3:38 AM
Hi All,
I have downloaded data from one database table into excel sheet.The date format of the downloaded data in the excel is yyyy.mm.dd but I want the date format as yyyymmdd (8 char in length).Can any one help me in this regard?
Waiting eagerly for your response.
Thanks and regards
Raj
04-14-2010 3:53 AM
Hi,
Move the date into a field of character type and then do the download.
copy those 8 characters into that character field and then update the internal table and finally do the download.
Regards,
Venkatesh
04-14-2010 4:02 AM
Hi Venkatesh,
Thanks for your quick response.I am not using any internal table.I am directly downloading the records from a database table to excel sheet.In that excel sheet I want the date format as yyyymmdd instead of yyyy.mm.dd .Can you please help
Raj
04-14-2010 5:36 AM
Hope you are downloading data from se16. If yes, data will be downloaded as the data is visible in SE16. If you want to change the format, write a small program to store the table data in internal table. In the internal table, change the field format as per your requirement and download the data from internal table.
Regards
Vinod
04-14-2010 4:02 AM
Try Uning and take the data type as type c length 8
CONVERT_DATE_TO_INTERNAL
Hope it helps
04-14-2010 5:54 AM
Hi Rajarshi,
After downloading the dat from database table into Excel.
Right click on any cell of excel-->selct FORMAT CELL...>NUMBER(tab)---> Select Date category and Right side select
required date format.
Regards,
Pravin
04-14-2010 6:01 AM
Hello,
Use the report BCALV_XXL_TOGGLE_DATE.
See SAP notes 358644 and 316814.
Regards,
David