Date Format Error

[Former Member]

Hi frends,

iam working in file_rfc_file scenario in PI7.1.my source data type as XSD:Date format is dd/mm/yyyy and in rfc it as yyyy/mm/dd

Using Data transfer function i hve made all changes but iam stil iam geeting the same error as.

could not convert request from XML to RFC:com.sap.mw.jco.JCO$ConversionException: (122) JCO_ERROR_CONVERSION: Date '2010/05/12' has a wrong format at field DATUV: Unparseable date: "2010/05/12"

my input xml is.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Mt_Ecsin xmlns:ns0="http://a.com/xi/erp/n47">

<Ecsin>

<Datuv>12/05/2010</Datuv>

<Equnr>10000958</Equnr>

<Stlan>4</Stlan>

<Stlty>E</Stlty>

<Trtyp>*</Trtyp>

<Werks>1000</Werks>

</Ecsin>

</ns0:Mt_Ecsin>

Help me out to sort this issue

With Regards,

Dinesh

[Shabarish_Nair · Accepted solution]

>

> could not convert request from XML to RFC:com.sap.mw.jco.JCO$ConversionException: (122) JCO_ERROR_CONVERSION: Date '2010/05/12' has a wrong format at field DATUV: Unparseable date: "2010/05/12"

if this is a JCO exception during the RFC call, then this is definitly because of the date format. the internal date format in SAP is YYYYMMDD. so have the date converted to tht format before making the RFC call

http://www.sapdb.org/7.4/htmhelp/48/0d8018b4f211d2a97100a0c9449261/content.htm

[Former Member · Accepted solution]

hi vijay,

input data format is :dd/mm/yyyy

outformat is : yyyy/mm/dd i have give ths in date transfer...but iam stil gettg the same error...kindly help me put...

With Regards,

Dinesh

[Shabarish_Nair · Accepted solution]

>

> hi vijay,
> 
> input data format is :dd/mm/yyyy
> outformat is : yyyy/mm/dd i have give ths in date transfer...but iam stil gettg the same error...kindly help me put...
> 
> With Regards,
> Dinesh

not YYYY/MM/DD but YYYYMMDD (without / )

[Former Member · Accepted solution]

Thnk u vijay solved

With Regards,

Dinesh

[balaji_pichaimuthu · Accepted solution]

Hi,

Happy to hear that ur problem solved. I belive you are new to sdn so my kind is giving points for useful answers would be appropriate way close the thread. Good luck

Regards,

Balaji

[Former Member]

Hi Dinesh,

In general the standard RFCs expecting the date format as "YYYYMMDD" so change the date format and try again, it solves your problem.

Use the date format with out delimeter ' / '.

Regards

Ramesh

[Former Member]

Hi,

I think u r data transformation is wrong.As per my understand RFC(SAP) requires date type is

YYYY/MM/DD.But u made it in to YYYY/DD/MM and also check with data type of both the elements are 'DATE' data type.

Thanks

Ravi

[balaji_pichaimuthu]

Confirm which date format RFC expecting,

YYYY/MM/DD or YYYY/DD/MM. I guess RFC expecting YYYY/MM/DD and you are converted to YYYY/DD/MM.

Regards,

Balaji