Date conversion

[Former Member]

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

[Former Member]

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.

[Former Member]

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................

[Former Member]

Hi ,

Try using the FM CONVERT_DATE_TO_EXTERNAL:

Regards

Arun

[Former Member]

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 '.'.

[Former Member]

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.

[Former Member]

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