âShow Table of Contents
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.
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â.
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.
Click Apply to have the configurations accepted.
Note: For information regarding Input, Output, Annotation and Error Properties, see Tool Properties.