You can use a type conversion to convert the data to match the format as required in the target. With a type conversion, you can convert values from any type to string or from string to any type. Usually, the string value is the external value.
Note
Type conversions from any type to any type are not supported. For example, a conversion of type integer to type date is not possible.
Conversion types
You can use these conversion types:
Conversion type | Description |
|---|---|
Text | Define the format in which a text is imported or exported. You can, for example, replace or remove characters, or use one element of the text. |
Amount | Define the format in which an amount is imported or exported. You can, for example, define separators and unit conversion. |
Date | Define the format in which a date is imported or exported. You can, for example, define the sequence and separator. |
Enum | Define the format in which an enum value is imported or exported. You can, for example, define that the enum value is imported or exported as text. |
Time | Define the format in which times are imported or exported. You can define the format and the separators to be used. |
UtcDateTime | Define in which format a date and time field value is imported or exported. This type combines the Date and Time types. |
Date/time format | Define in a flexible way the format in which a date and time field value is imported or exported. You can also include a time zone. Note: The format is case sensitive. For example, the lowercase 'm' is the identifier for minute, and the uppercase 'M' is the identifier for month. |