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	Y	Defines the field name before mapping.
to	Y	Defines the field name after mapping.
precedence	N	Defines the precedence used when mapping.
Function type	Y	Defines the function type of the mapping. Must be set to "Date function".
Function	Y	Defines the type of mapping. Must be set to "Convert dates to a desired format".
Replacement string	Y	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