In this use case we are going to explore how the custom mapping tool can be used to map a date field from the source structure format to a new format in the target structure.
In order to create the custom mapping, we are going to use the Format Date node function. The Format Date node function requires an argument as the desired date format EX: [Y0001]-[D01]-[M01].
In this scenario, we are going to create a custom mapping for the PurchaseOrderExportRequest document type. The creationDateString field is currently in YYYY-MM-DD and we are going to map it to DOCDATE_USERTIMEZONE filed in the target and format it as YYYY-DD-MM.
Follow the simulation below to create the mapping.