topic Re: Changes required in date format in Application Development and Automation Discussions

Changes required in date format

Former Member — Wed, 14 Apr 2010 02:38:54 GMT

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

Re: Changes required in date format

Former Member — Wed, 14 Apr 2010 02:53:34 GMT

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

Re: Changes required in date format

Former Member — Wed, 14 Apr 2010 03:02:21 GMT

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

Re: Changes required in date format

anup_deshmukh4 — Wed, 14 Apr 2010 03:02:58 GMT

Try Uning and take the data type as type c length 8

CONVERT_DATE_TO_INTERNAL

Hope it helps

Re: Changes required in date format

Former Member — Wed, 14 Apr 2010 04:36:17 GMT

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

Re: Changes required in date format

Former Member — Wed, 14 Apr 2010 04:54:04 GMT

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

Re: Changes required in date format

DavidLY — Wed, 14 Apr 2010 05:01:03 GMT

Hello,

Use the report BCALV_XXL_TOGGLE_DATE.

See SAP notes 358644 and 316814.

Regards,

David