Problem with time stamp conversion

[Former Member]

Hi All,

I am using the below code to convert timestamp to date and time , its working fine when i print it with write statement .

But i want to convert and pass the time and date with format to excel sheet , but its it taking again as string not in date time format .

please see the below code .

time_stamp = 20030309043000.

CONVERT TIME STAMP time_stamp TIME ZONE tz

INTO DATE dat TIME tim.

*WRITE: /(10) dat, (8) tim .

please suggest .

[Former Member]

Hi,

Not sure I got this... can't you simply use a 'WRITE TO' when filling your internal table fields before downloading, so that your strings are correctly formatted and interpreted as such by excel?

Kr,

Manu.

[Former Member]

Now that you've converted your time stamp to date (type d) and time (type t), convert them into alphnumeric fields like you want or tell excel what is in that column, since Excel isn't telepathic...and doesn't always know what we sent it....

data: date10(10) type c.

time8(8) type c.

write dat to date10 mm/dd/yyyy. "converts type d to user's specific date setting (not necessarily mm/dd/yyyy).

concatenate tim(2)

tim+2(2)

tim+4(2)

into time8 separated by ':'.

I do wish that I understood the fascination with Excel....when we have such marvelous tools to work with inside SAP or BW.

[Former Member]

Hi ,

It worked out .. Thanks to BreakPoint .....

[former_member203501]

Hi ,

use the function module IB_CONVERT_FROM_TIMESTAMP for your requirement, speciy the time stamp and time zone.

[former_member209696]

I think venkat's solution is the perfect one. u can use IB_CONVERT_FROM_TIMESTAMP and pass time stamp and region and get time and date .

I pblm solved close the thread...

[Former Member]

Hi ,

I already tried the function module suggested by Venkat , Yes it will convert it to proper fomate but again the same issue when I am passing it to excel its taking it as string .