topic Re: conversion routine in Application Development and Automation Discussions

conversion routine

Former Member — Mon, 15 Mar 2010 09:39:32 GMT

if i have a data in flat file like a date = 30.10.2010 so this date i want to convert in sap format and sap allow only 10/30/2010 . how to do that with bdc

Moderator message - Please see before posting - post locked

Edited by: Rob Burbank on Mar 21, 2010 6:45 PM

Re: conversion routine

former_member70391 — Mon, 15 Mar 2010 10:51:51 GMT

Hello Kapoor,

It is always better to change the date format according to date format in user settings. You can check it via SU3->Default.

User belongs to different countries use different date format so u can need to write a code in such way that it will not create problems for any date format. I have given the code below which will help you to achieve this goal.

Moderator message - Please respect the 2,500 character maximum when posting. Post only the relevant portions of code

Thanks,

Nagaraj

Edited by: Rob Burbank on Mar 21, 2010 6:44 PM

Re: conversion routine

Former Member — Mon, 15 Mar 2010 10:53:11 GMT

Hi,

This shud do the trick..

date = 30.10.2010

concatenate date3(2) '/' date0(2) '/' date+6(4) into date1.

Use date1 it will have the format you require. Pls note date and date1 should be character or string variables.

Thanks

Mani

Re: conversion routine

andreas_mann3 — Mon, 15 Mar 2010 12:02:52 GMT

use fm CONVERT_DATE_TO_INTERNAL

Re: conversion routine

ThomasZloch — Mon, 15 Mar 2010 12:19:02 GMT

basic date question...locked.

Thomas