topic Re: problem in exporting dates table to excel in Application Development and Automation Discussions

problem in exporting dates table to excel

anoop_gupta2 — Tue, 20 May 2008 07:47:09 GMT

hey experts,

i have a problem with exporting data to excel sheet .

1) when i export date it converts into string format and stores in the excel sheet ex: "02.02.2008"

but the problem here is that when i revert back the excel data to abap internal table , it is not working since the date is now in string format ..

please help urgently.

Point will b rewarded suitably.

thx and regards,

Anoop Gupta

Re: problem in exporting dates table to excel

Former Member — Tue, 20 May 2008 07:55:44 GMT

Hi,

After you import the data into internal table, loop at the table and convert date back to YYYYMMDD format using the FM : CONVERT_DATE_TO_INTERNAL

Shruthi

Re: problem in exporting dates table to excel

Former Member — Tue, 20 May 2008 08:03:31 GMT

CONVERT_DATE_TO_INTERNAL

export

external date = intrenal table date field

import

DATE_INTERNAL = to internal table field

dont forget to apend the dates after processing

Re: problem in exporting dates table to excel

anoop_gupta2 — Tue, 20 May 2008 10:23:01 GMT

hey thankx for the immediate reply , but still the problem is that , when i am am receiving the excel sheet data , i have no idea about which filed is having the date value . so first i need to find out the field in which date is stored and then only i can apply that RFC .

so can u please suggest some other work around or a method to know which filed is having date .

Any help will be appreciated and will be rewarded.

Thx & Regards.

Anoop