topic Re: lsmw date format problem in Application Development and Automation Discussions

lsmw date format problem

Former Member — Thu, 20 Oct 2005 07:33:48 GMT

hi,

using lsmw i'm reciving an error :

"Enter date in format __-__-____"

My source field is DYMD and I have for example "20041010" as a date. (DYMD is 8 lenght).

Any idea what is wrong?

Lukasz

Re: lsmw date format problem

Vinod_Chandran — Thu, 20 Oct 2005 07:38:06 GMT

Hi,

The date format depends upon the date format specified in the user master. Check the user in SU01 transaction. It seems the field expects a format 'DD-MM-YYYY'. Try passing either '20041010' or '10-10-2004'.

Cheers

Vinod

Re: lsmw date format problem

sergey_korolev — Thu, 20 Oct 2005 08:30:35 GMT

Hi Lukasz,

That's likely because your LSMW project uses BDC as an input method and the corresponding field excpects external date format.

Try to use external date format with length 10 (DD.MM.YYYY)

Re: lsmw date format problem

Former Member — Thu, 20 Oct 2005 08:59:20 GMT

hi Lukasz Gruca

TRY THESE fUNCTION MODULES.MIGHT BE THEY SOLVE YOUR PROBLEM.

CONVERTING DATE(10) TO DATE(8)

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

DATE_EXTERNAL = VAR_DATE1

IMPORTING

DATE_INTERNAL = VAR_INDAT.

CONVERT_DATE_TO_EXTERNAL

This Function module Converts date from system storage format to users specified display format

cheers,

Vijay Raheja.

Re: lsmw date format problem

Former Member — Thu, 20 Oct 2005 09:20:31 GMT

thx Vijay Raheja.

That's solved my problem.

cheers

Lukasz Gruca

Re: lsmw date format problem

Former Member — Wed, 27 Sep 2006 21:36:07 GMT

hi Lucas

I have the same problem with date for my LSMW asset load. Could you explain how you used the function.

If possible can you send me detailed documentation if you have any.

Thanks much

Krishna