topic Re: Date Conversion in Application Development and Automation Discussions

Date Conversion

Former Member — Thu, 12 Jan 2006 10:30:57 GMT

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

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:32:43 GMT

Use write to statement

Data v_datum(10).

write sy-datum to v_datum.

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:35:16 GMT

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

But it is not working.

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:38:35 GMT

Hi Jeetu,

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

Regards,

Nagarajan.

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:38:36 GMT

I have tried it and its working for me..

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:40:44 GMT

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

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:47:48 GMT

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

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:47:50 GMT

Alternatively to make the logic to work,

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

Regards,

ravi

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:48:30 GMT

Alternatively to make the logic to work,

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

Regards,

ravi

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 10:48:43 GMT

Alternatively to make the logic to work,

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

Regards,

ravi

Re: Date Conversion

Former Member — Thu, 12 Jan 2006 11:31:21 GMT

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.