05-19-2008 7:38 AM
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
05-19-2008 7:42 AM
Hi,
Use write instead of move and try.
write tab-date1 to itab-date.
Thanks and regards,
S. Chandramouli.
05-19-2008 7:40 AM
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
05-19-2008 7:42 AM
Hi,
Use write instead of move and try.
write tab-date1 to itab-date.
Thanks and regards,
S. Chandramouli.
05-19-2008 7:56 AM
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