Use the FormatDate function to change date and time information from one format to another. The data type of the column that is selected in the Input column field determines the data type for the output column. For example:
Input columns of Date type will become Date types in the output columns.
Input columns of Time type will become Time types in the output columns.
Input columns of Timestamp type will become Timestamp, Date, or Time types in the output columns, depending on the category that you select for the output.
To change the format of date and time information:
In the Expression Builder, double-click FormatDate in the list of function names. The Function Arguments - FormatDate window opens.
In the Function Arguments - FormatDate window, click the column in the Available columns list that contains date or time information that you want to reformat, then click > to place the selected field in the Input column.
Specify the input format in the Input Format area of the window:
Select a category for the input column data from the Category list.
Select a date, time, or timestamp format from the Format list. The Example list shows an example of the format that you select. The Format string field confirms your selection. You can also specify a format by typing directly in the Format string field.
Specify the output format in the Output format area of the window:
Select a category for the output column data from the Category list.
Select a data or time format from the Format list. The Example list shows an example of the format that you select. The Format string field confirms your selection. You can also specify a format by typing directly in the Format string field.
Click OK. The Function Arguments - FormatDate window closes, and the expression is displayed in the Expression Builder window.
Related information
Function Arguments - FormatDate window - Fields and controls