Changing Date format of a XML code

[former_member791832]

How do I change the date format of the incoming XML code (Employee data of 6 employees) from dd-MM-YYYY to YYYY-mm-dd in the iflow.

Example: <?xml version='1.0' encoding='UTF-8'?>

<EmployeeData>

<Employee>

<ID>1</ID>

<Name>Raam</Name>

<DOJ>19-07-2016</DOJ>

<Country>IND</Country>

</Employee>

<Employee>

<ID>2</ID>

<Name>Siva</Name>

<DOJ>18-07-2016</DOJ>

<Country>IND</Country>

</Employee>

<Employee>

<ID>3</ID>

<Name>John</Name>

<DOJ>01-11-2011</DOJ>

<Country>US</Country>

</Employee>

<Employee>

<ID>4</ID>

<Name>Shane</Name>

<DOJ>19-05-2013</DOJ>

<Country>US</Country>

</Employee>

</EmployeeData>

[babruvahana · Accepted solution]

Hi Ramya,

What is the error/issue you are facing?

Did you try with the Date function from Graphical mapping or did you use groovy script for date format conversion or xslt code or used it in content modifier?

Regards,

Pavan

[former_member791832 · Accepted solution]

Hi Pavan,

I tried with groovy script was not working for the entire code and found that I could do this Graphical mapping itself and voila it worked.

Thanks for responding!