topic Re: date Problem in Application Development and Automation Discussions

date Problem

Former Member — Wed, 19 Dec 2007 07:17:27 GMT

Hello friends,

I have a problem in a report program in which i am downloading data to an excel file.

Excel file contains date column in which date gets downloaded as 20070618,

But I need to get this data as 06/25/2007

Can I know which FM achieves this result format.

i have tried using Cocatenation syntax but its of no help.

So can anyone help me in this regard..

Regards,

Sapna Agarwal.

Re: date Problem

former_member188829 — Wed, 19 Dec 2007 07:21:28 GMT

Hi ,

Use the FM:CONVERSION_EXIT_PDATE_OUTPUT

Re: date Problem

Former Member — Wed, 19 Dec 2007 07:23:01 GMT

Check this FM.

CONVERSION_EXIT_PDATE_OUTPUT

try this also.

Data: date1 type sy-datum,

date2(10) type c.

Date1 = sy-datum. " This will be in YYYYMMDD format

Concatenate date14(2) date16(2) + date1+0(4) into date2 seperated by '/'.

write date2.

Regards,

Maha

Re: date Problem

former_member386202 — Wed, 19 Dec 2007 07:26:37 GMT

Hi,

While declaring the structure or thast internal table declare that date field as character type.

Regards,

Prashant

Re: date Problem

Former Member — Wed, 19 Dec 2007 07:35:48 GMT

Hi Agarwal,

Try any one of this funcation modules.

CONVERSION_EXIT_PDATE_OUTPUT

CONVERSION_EXIT_SDATE_OUTPUT

CONVERSION_EXIT_IDATE_OUTPUT

(or) Try This code.

data: w_date type sy-datum value '20071219',

w_temp(10).

CONCATENATE w_date6(2) '/' w_date4(2) '/' w_date(4) into w_temp.

write w_temp.

Plzz Reward if useful,

Mahi.

Re: date Problem

Former Member — Wed, 19 Dec 2007 07:42:02 GMT

good

change the data format as from YY MM DD TO DD MM YY before the data pass from the internal table to the screen sequence.

For converting the date format i would suggest you to change the date format only which ll work fine.

thanks

mrutyun^