Text -> date:

Time format contains characters that are not indicated by quotation marks and are not available as date characters in the transferred language.

The operator returns no data.

Error message

Text -> date:

Column contains non-empty strings that do not match the time format.

The incorrect cell remains empty in the target column. The data type change for the column is continued for the remaining rows.

Warning message.

Text -> date:

Column contains empty cells

The incorrect row remains empty. The data type change for the column is continued for the remaining rows.

Warning message.

Text -> number:

Column contains strings that cannot be directly interpreted as numbers, e.g., because they contain units.

Tolerance:

All non-numerical characters are ignored and a numerical value is created from the rest.

Exception:

If, e, E, +e, +E, or -E is embedded in figures, they are interpreted as part of "computerized scientific notation" of the number and are not ignored. No message is output.

Error:

If the string is still not successfully changed, the affected cell remains empty.

Warning message

Number -> date:

The source number has decimal places.

The number is rounded to a value without decimal places and the data type is changed using this value.