topic Re: Function module CONVERT_DATE_TO_INTERNAL in Application Development and Automation Discussions

Function module CONVERT_DATE_TO_INTERNAL

Former Member — Mon, 03 Feb 2014 09:22:24 GMT

Function module CONVERT_DATE_TO_INTERNAL is used to convert date to SAP internal format.Does it work if the flat file date is in "DD/MM/YYYY" format or "MM/DD/YYYY" format?

Re: Function module CONVERT_DATE_TO_INTERNAL

nabheetscn — Mon, 03 Feb 2014 09:29:40 GMT

Why dont you try it in SE37

Re: Function module CONVERT_DATE_TO_INTERNAL

former_member212705 — Mon, 03 Feb 2014 09:32:29 GMT

Hi Arun,

Sure it will work , but your flat file date format should be matched with user External format. say your file has format YYYY/MM/DD and your external format is same then it will work otherwise it fails.

Regards,

Ashish

Re: Function module CONVERT_DATE_TO_INTERNAL

Former Member — Mon, 03 Feb 2014 09:51:42 GMT

Hi Arun,

This FM CONVERT_DATE_TO_INTERNAL will only accept the date format which is in only dd.mm.yyyy . The other it will not accept. Once try this FM in SE37 .

Thanks,

S.Rajendranath

Re: Function module CONVERT_DATE_TO_INTERNAL

former_member212705 — Mon, 03 Feb 2014 09:57:20 GMT

No Sheshadri,

It accepts the format same as user external format set in transaction SU3. go to SU3 change your external format of date then Try. It works only if date format is same as external format set in SU3.

Re: Function module CONVERT_DATE_TO_INTERNAL

Former Member — Mon, 03 Feb 2014 10:15:25 GMT

Thanks Ashish.

Re: Function module CONVERT_DATE_TO_INTERNAL

Former Member — Mon, 03 Feb 2014 10:27:26 GMT

Hi Sheshadri,

I tested in se37.As said by Ashish it works fine only if flat file date is in same format as date in SU3.