Input columns

System.Object

opt.

Which columns are to be converted?

col1

Select date format (input data)

System.String

• dd.MM.yyyy HH:mm:ss
• dd.MM.yyyy HH:mm
• dd.MM.yy HH:mm:ss
• dd.MM.yy HH:mm
• d.M.yyyy HH:mm:ss
• d.M.yyyy HH:mm
• d.M.yy HH:mm:ss
• d.M.yy HH:mm
• dd.MM.yyyy
• dd.MM.yy
• d.M.yyyy
• d.M.yy
• yyyy-MM-dd HH:mm:ss
• yyyy-MM-dd HH:mm
• M\/d\/yyyy h:mm tt

-

Select data format in which the input data is present

-

or enter format string

System.String

opt.

Enter date format in which the input data is present (C#-syntax)

dd.MM.yy

Select date format (result data)

System.String

• dd.MM.yyyy HH:mm:ss
• dd.MM.yyyy HH:mm
• dd.MM.yy HH:mm:ss
• dd.MM.yy HH:mm
• d.M.yyyy HH:mm:ss
• d.M.yyyy HH:mm
• d.M.yy HH:mm:ss
• d.M.yy HH:mm
• dd.MM.yyyy
• dd.MM.yy
• d.M.yyyy
• d.M.yy
• yyyy-MM-dd HH:mm:ss
• yyyy-MM-dd HH:mm
• M\/d\/yyyy h:mm tt

-

Select date format in which the result should be presented

-

Date format (result data)

System.String

opt.

Enter date format in which the result should be presented (C# syntax)

d.M.yy HH:mm

Issue success column

System.Boolean

opt.

Must an additional column in the result be issued for each input column which shows whether the conversion was successful?

-

Prefix of success column

System.String

-

Prefix of the result column Success/No success

Success_

Prefix column value

System.String

-

Prefix of the result column for the converted value

Value_

Max. number of errors (0=unlimited)

System.Int32

-

Number of erroneous conversions after which the operator stops. The value 0 means no restriction.

20

-