Type in the header name you wish to extract. In this case, the header is "Trd DateTime".

Link the "Source Field" card to the "Date Time Converter" card by clicking and dragging a line like so.

"effectiveDate"
View details

Unadjusted date at which obligations under the OTC derivative transaction come into effect, as included in the confirmation.

Source Field
Close view

Extracts a value by the header (or xml path) provided in the Source Field.

Source Field
Date Time Converter
Close view

Returns converted dateTime from input format to output format.

Select Input Format
Custom
Predefined
Select
Select Input Time Zone
UTC
Select Output Format
Custom
Predefined
Select

You have now connected the "Source Field" card to the "Date Time Converter" card.

You can select from a predefined list of date and timestamp formats.

Alternatively, you can define a custom date & time format to extract from your Source Field.

You may enter your custom date & time format in the textbox. You may validate that the format you've entered has the correct syntax by viewing the example current timestamp shown right below the textbox.

Here you can set the time zone of your "Source Field" date & time. In this case, it is UTC.

You can convert the input date and timestamp into a format from a predefined list.

The "effectiveDate" KDM field accepts "yyyy-MM-dd" format.

Link the "Date Time Converter" card to the "effectiveDate" card by clicking and dragging a line like so.

Source Field
Close view

Extracts a value by the header (or xml path) provided in the Source Field.

Source Field
Date Time Converter
Close view

Returns converted dateTime from input format to output format.

Select Input Format
Custom
Predefined
Format

Example (curr. datetime)
20250212 04:09:57

Select Input Time Zone
UTC
Select Output Format
Custom
Predefined
yyyy-MM-dd

Example (curr. datetime)
2025-02-12

"effectiveDate"
View details

Unadjusted date at which obligations under the OTC derivative transaction come into effect, as included in the confirmation.

You have now connected the "Date Time Converter" card to the "effectiveDate" card.

Source Field
Close view

Extracts a value by the header (or xml path) provided in the Source Field.

Source Field
Date Time Converter
Close view

Returns converted dateTime from input format to output format.

Select Input Format
Custom
Predefined
Format

Example (curr. datetime)
20250212 04:10:01

Select Input Time Zone
UTC
Select Output Format
Custom
Predefined
yyyy-MM-dd

Example (curr. datetime)
2025-02-12

"effectiveDate"
View details

Unadjusted date at which obligations under the OTC derivative transaction come into effect, as included in the confirmation.

Make sure you remember to add a note for clarity to future users on what has been mapped.

Type in your notes on what has been mapped and other relevant information.

Click "Update" to save your configuration.

Extraction of Date from Source Field for Mapping to KDM