cancel
Showing results for 
Search instead for 
Did you mean: 

Date Format Error

Former Member
0 Kudos

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

View Entire Topic
Shabarish_Nair
Active Contributor
0 Kudos

>

> 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
0 Kudos

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
Active Contributor
0 Kudos

>

> 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
0 Kudos

Thnk u vijay solved

With Regards,

Dinesh

balaji_pichaimuthu
Active Participant
0 Kudos

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