Date Conversion in User Profile format

Former Member — Wed, 21 Nov 2007 07:06:42 GMT

Hi,

I want date as report ouput in the format set in User Profile (su01)

for example: date is cming in YYYYMMDD format from the table and in my userprofile it is set as DD.MM.YYYY, it shud give o./p in DD.MM.YYYY format.

I have tried with FUnction Module CONVERT_DATE_TO_EXTERNAL.

But its not working and giving o/p in MM/DD/YYYY format eventhough i have set date format as DD.MM.YYYY in my profile.

Kindly suggest any other way.

Thanks In Advance.

Sapna

Re: Date Conversion in User Profile format

Former Member — Wed, 21 Nov 2007 14:10:34 GMT

Dear Sapna,

The simple way to convert the date in user format is to use WRITE statement. Find the below e.g.,

DATA:

lv_date TYPE sydatum,

lv_char TYPE char10.

lv_date = '20071121'.

WRITE lv_date TO lv_char.

WRITE lv_char.

Regards

Kesava