move_date_format

[naveen_inuganti2]

Hi friends...

Iam down loanding one internal table data...into excel file with gui_download....

it contains no. of fields including onwe date field...

i filled that field like this...

move: tab-date1 to itab-date1.

before this i declared data: itab-date1(10) type c.

here my problem is iam getting.... 05/18/2008(today) format for...list out put which is goingto be display with tab-date1 field...

but..... in excel iam getting...

like...

20080518....which is from itab-date1...

how to get correct format from itab-date1 field....

Thank you,

Naveen

[prasanth_kasturi]

hi

intrenally the date is store as yyyymmdd.

and the dispaly will according your settings

so when you download you will get the format like yyyymmdd

and when you upload again the date will be as your o/p settings

if you still want o/p for ex as 22/12/2008

you must store the exact value 22/12/2008 with slash in the varible using concantenate

regards

prasanth

[former_member784222]

Hi,

Use write instead of move and try.

write tab-date1 to itab-date.

Thanks and regards,

S. Chandramouli.

[Former Member]

Hi,

After displaying the data on the output screen.

do the follwing

loop at itab.

concatenate itab-date14(2) itab-date16(2) itab-date1+0(4)

into itab-date1 separated by '/'.

modify itab.

endloop.

Edited by: Velangini Showry Maria Kumar Bandanadham on May 19, 2008 8:56 AM