problem in exporting dates table to excel

[anoop_gupta2]

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

[Former Member]

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

[Former Member]

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

[anoop_gupta2]

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