You are here: Tools > All Tools > Date Time

About the Date Time Tool

The Date Time tool standardizes and formats date/time data so that it can be used in expressions and functions from the Formula or Filter tools.

Dates cannot be before January 01, 1900 to be utilized in the Date Time Tool.

Configuration Properties

  1. Choose the Conversion mode. Choices are:

    • Convert From Date/Time Field to Formatted String: Takes a Date field with the native format:yyyy-MM-dd hh:mm:ss (e.g., 2006-02-23 14:55:00), and converts it to the string format of the user's choosing
    • Convert From String Field to Date/Time Field: Takes a String field with a specified format, and converts it to the extended ISO format:yyyy-MM-dd hh:mm:ss (e.g., 2006-02-23 14:55:00)

    The input data must have at least one field that is of the type ” Date”, ” Time”, or ”DateTime”. Otherwise, the input drop down list will be disabled, with the label above the list stating ” No Suitable Input Fields Available”.

  2. Select the Input Field to convert
  3. Select the format to convert to/from. For more information, consult the Date/Time Format Types.

    If you would like to specify your own DateTime format, see the DateTimeParse and DateTimeFormat functions in the Formula tool.

  4. Specify the name of the Output Formatted String Field. The default is DateTime_Out.

Click Apply to have the configurations accepted.

Note: For information regarding Input, Output, Annotation and Error Properties, see Tool Properties.

Related Topics Link IconRelated Topics