c

DateTime Tool

The DateTime tool transforms DateTime data to and from a variety of formats, including both expression-friendly and human readable formats.

Date support

Designer cannot process dates prior to January 1, 1400.

Configure the tool

Select the format to convert.

  • Date/Time format to string: Converts DateTime data in the yyyy-MM-dd format or yyyy-MM-dd hh:mm:ss format to a string.
    • Select the date/time field to convert: Select from the list. The field is greyed out and reads "No Suitable Input Fields Available." if no DateTime columns are present.
    • Specify the new column name: Enter a new column name or use the default DateTime_Out.
    • Select the format for the new column: Select a format from the list, or select Custom to create your own format in Specify a custom format for the new column.
  • String to Date/Time format: Converts string data to a DateTime format in the yyyy-MM-dd format or yyyy-MM-dd hh:mm:ss format.
    • Select the string field to convert: Select from the list. The field is greyed out and reads "No Suitable Input Fields Available." if no DateTime columns are present.
    • Specify the new column name: Enter a new column name or use the default DateTime_Out.
    • Select the format that matches the incoming string field: Select a format from the list, or select Custom to identify a different format in Specify the format of the incoming string field.

Custom formats

Select Custom to enter your own format. Designer displays an example based on the format you enter.

You can use the specifiers and separators as described below (for example, dd, MM, yyyy), or the specifiers and separators supported by the DateTimeParse and DateTimeFormat DateTime functions (for example, %d, %m, %Y).

You can use an asterisk * as a wildcard character to replace any character in the date format field.