date Problem

[Former Member]

Hello friends,

I have a problem in a report program in which i am downloading data to an excel file.

Excel file contains date column in which date gets downloaded as 20070618,

But I need to get this data as 06/25/2007

.

Can I know which FM achieves this result format.

i have tried using Cocatenation syntax but its of no help.

So can anyone help me in this regard..

Regards,

Sapna Agarwal.

[former_member188829]

Hi ,

Use the FM:CONVERSION_EXIT_PDATE_OUTPUT

[Former Member]

Check this FM.

CONVERSION_EXIT_PDATE_OUTPUT

try this also.

Data: date1 type sy-datum,

date2(10) type c.

Date1 = sy-datum. " This will be in YYYYMMDD format

Concatenate date14(2) date16(2) + date1+0(4) into date2 seperated by '/'.

write date2.

Regards,

Maha

[former_member386202]

Hi,

While declaring the structure or thast internal table declare that date field as character type.

Regards,

Prashant

[Former Member]

Hi Agarwal,

Try any one of this funcation modules.

CONVERSION_EXIT_PDATE_OUTPUT

CONVERSION_EXIT_SDATE_OUTPUT

CONVERSION_EXIT_IDATE_OUTPUT

(or) Try This code.

data: w_date type sy-datum value '20071219',

w_temp(10).

CONCATENATE w_date6(2) '/' w_date4(2) '/' w_date(4) into w_temp.

write w_temp.

Plzz Reward if useful,

Mahi.

[Former Member]

hi

good

change the data format as from YY MM DD TO DD MM YY before the data pass from the internal table to the screen sequence.

For converting the date format i would suggest you to change the date format only which ll work fine.

thanks

mrutyun^