Convert dates to a desired format

The "Convert dates to a desired format" function converts any supported date format into a desired date format.

---

Supported Date Formats (in the from field)

• yyyy-MM-dd'T'HH:mm:ss.SSSXX
• yyyy-MM-dd HH:mm
• yyyy-MM-dd'T'HH:mm:ss.SSS'Z'XX
• yyyy-MM-dd'T'HH:mm:ss
• yyyy-MM-dd HH:mm:ss
• yyyy/MM/dd'T'HH:mm:ss.SSSXX
• yyyy/MM/dd HH:mm
• yyyy/MM/dd'T'HH:mm:ss.SSS'Z'XX
• yyyy/MM/dd'T'HH:mm:ss
• yyyy/MM/dd HH:mm:ss
• yyyy-MM-dd
• yyyy/MM/dd
• dd/MM/yyyy
• MM/dd/yyyy
• d MMMM yyyy

---

Replacement String

The Replacement string attribute in the mapping specifies a pattern that constructs a java.text.SimpleDateFormat object.
Valid patterns can be found in the official Java documentation:
Java SimpleDateFormat Documentation

---

Attributes for Time Conversion Mapping

Attribute	Required	Description
From	Yes	Defines the field name before mapping.
To	Yes	Defines the field name after mapping.
Precedence	Yes	Determines the order in which this mapping is applied relative to others.
Function type	Yes	Defines the function type of the mapping. Must be set to "Date function".
Function	Yes	Defines the type of mapping. Must be set to "Convert dates to a desired format".
Replacement string	Yes	Defines the pattern for time conversion using SimpleDateFormat.

---

Usage Example

Replacement string	Value Before Mapping	Result After Mapping
hh:mm dd/MM/yyyy	2026-01-20T09:30:00	09:30 20/01/2026