topic Re: move_date_format in Application Development and Automation Discussions

move_date_format

naveen_inuganti2 — Mon, 19 May 2008 06:38:51 GMT

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 — Mon, 19 May 2008 06:40:57 GMT

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 — Mon, 19 May 2008 06:42:28 GMT

Hi,

Use write instead of move and try.

write tab-date1 to itab-date.

Thanks and regards,

S. Chandramouli.

Former Member — Mon, 19 May 2008 06:56:33 GMT

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