Summary

Converts string values into the data type Date.

Configuration

Input settings of existing table

Name

Value

Opt.

Description

Example

Input columns

System.Object

opt.

Which columns are to be converted?

col1

Settings

Name

Value

Opt.

Description

Example

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

Want to learn more?

Screenshot

Examples

Example: Birthdays

Situation

In this example the goal is to convert birthdays that are saved as a string to a DateTime object

Settings

Result

Project-File

-


Troubleshooting

Nothing known up to now.

Related topics