Converting a DateTime element to a string

Use the FormatDateTime function to convert an element with a DateTime data type to a string with a different date format.

<order>
	<orderDate>2020-08-21T12:39:20.970Z</orderDate>
	<orderId>168484984</orderId>
</order>

1. Open your input structure and click the orderDate element, then click Read Only and select Editable in the drop-down list.
2. In the Data Type drop-down list, select Date/Time.
3. Create a map with your input and output structures and drag and drop the input orderId element on the corresponding output.

   

4. Click the output orderDate element and drag a FormatDateTime function in the Value tab.
5. Double-click the function to open its properties and enter the new date pattern in the Pattern field.

   Example

   yyyyMMdd
6. Click OK.
7. Drag the input orderDate element on the Value argument and save the map.

   Example

   

<order>
  <orderDate>20200821</orderDate>
  <orderId>168484984</orderId>
</order>