topic Re: Date conversion in Application Development and Automation Discussions

Date conversion

Former Member — Thu, 08 May 2008 10:13:26 GMT

Hi Guru,

My internal table date is 20081119 in this format.

But I want the data as 19.11.08. Is there any function module.

Please help me.

Reward maximum point.

Thanks,

Sandeep Garg

Re: Date conversion

Former Member — Thu, 08 May 2008 10:16:19 GMT

Hi,

try this,

CONCATENATE P_S_BILLDT_LOW4(2) P_S_BILLDT_LOW6 P_S_BILLDT_LOW+0(2)

INTO P_L_DATE SEPARATED BY '.'.

regards,

muralidhar.

Re: Date conversion

Former Member — Thu, 08 May 2008 10:20:06 GMT

hi,

Yes there are function modules !!!!!

try these function modules :

'CONVERT_DATE_TO_EXTERNAL',

CALL FUNCTION '/SAPDII/SPP05_CONVERT_DATE'

and

CALL FUNCTION 'CONVERT_DATE_FORMAT'

Reward points if helpful................

Re: Date conversion

Former Member — Thu, 08 May 2008 10:20:45 GMT

Hi ,

Try using the FM CONVERT_DATE_TO_EXTERNAL:

Regards

Arun

Re: Date conversion

Former Member — Thu, 08 May 2008 10:21:16 GMT

20081119 in this format.

But I want the data as 19.11.08. Is

data: lv_date(10) type c.

concatenate sy-datum6(2) sy-datum4(2) sy-datum+2(2) into lv_date separated by '.'.

Re: Date conversion

Former Member — Thu, 08 May 2008 10:22:52 GMT

Hi,

data:v_date like sy-datum,

v_date1(10) type c.

Concatenate v_date6(2) v_date4(2) date+0(4) into vdate1separated by '.'.

RESULT = V_DATE1

Reward If useful

Regards,

Balaji.

Re: Date conversion

Former Member — Thu, 08 May 2008 10:22:59 GMT

check this..

report .

parameters:p_date(10) type c default '20081119'.

data: dat1(2),

dat2(2),

dat3(4),

date(10) .

dat3 = p_date+0(4).

dat2 = p_date+4(2).

dat1 = p_date+6(2).

concatenate dat1 dat2 dat3+2(2) into date separated by '.' .

write:/ date .

regards,

venkat