Date Conversion

[Former Member]

I want to coonvert sy-datum to mm/dd/yyyy form which is going to be a input field for BDC.

Could anyone help?

Thanks

[Former Member]

Use write to statement

Data v_datum(10).

write sy-datum to v_datum.

[Former Member]

I have tried write sy-datum to dt MM/DD/YYYY.

But it is not working.

[Former Member]

I have tried it and its working for me..

[Former Member]

Alternatively to make the logic to work,

Change the User settings for the date format to MM/DD/YYYY in SU3 transaction.

Regards,

ravi

[Former Member]

Alternatively to make the logic to work,

Change the User settings for the date format to MM/DD/YYYY in SU3 transaction.

Regards,

ravi

[Former Member]

Alternatively to make the logic to work,

Change the User settings for the date format to MM/DD/YYYY in SU3 transaction.

Regards,

ravi

[Former Member]

Hi Jeetu,

Check out this thread this might help u in solving ur problem.

Regards,

Nagarajan.

[Former Member]

try this.

data : c1(10) type c .

concatenate sy-datum4(2) '/' sy-datum6(2) '/' sy-datum+0(4) into c1.

Hope this helps you.

Message was edited by: Asit Garg

[Former Member]

I would like to thank all of u for your prompt response.

Everybody has been awarded the appropriate points.

Now the problem has been solved.

Regards,

Jeetu

[Former Member]

Hi,

Can you brief me the exact requirement. Before passing the date value to BDC, we need to findout the date settings in the system by using fm SLS_MISC_GET_USER_DATE_FORMAT, accordingly we need to convert input date format to system format.

Hope it solves your problem.