Invalid datetime value in XSLT SAP CPI

[former_member140163]

Hi,

I have a date field coming from a csv file to the Interface eg:"3/1/2017".

I have to convert it to yyyy-mm-dd format using format date in XSLT Mapping.

But getting a erro Invalid dateTime value "3/1/2017" (Non-numeric year component)

Can you help me to convert it to a date in XSLT in sap cpi?

[gwerner]

Hi Shruthi,

try this.

But the problem is the value of the delivered date format for day and month. There only one letter!

This is my xml

<root><br>    <Date1>3/1/2017</Date1><br></root>

Be also careful of the quotation mark than you have to move each step by one.

 <Date2><xsl:value-of select="concat(substring($dt,6,4),'-', substring($dt,4,1), '-', substring($dt,2,1))"/></Date2>

kind regards
Gunter

[balazsbence95]

Hi,

Please, remove tag SAP Cloud Integration for data services because this issue raised here has nothing to do with CPI-DS this particular tag is for.

Thank you,
Bence