Format dates

The Format dates step converts a column's date values to a new format. It's useful to use whenever you need to unify the date formats across various columns or change date structures into formats that make sorting by ascending or descending dates easier.

Input/output

Input data to be connected to this step needs at least one column with date data. In this example, we pass a column called "Order Date" that it currently formatted as MM/DD/YYYY.

By requesting the New Format to be YYYY-MM-DD, the output data looks like this: 2020-09-15.

Settings

When configuring the Format dates step, first Pick the dataset, then select the column(s) that you'd like to format. If you have multiple columns that have the same starting format that you'd like to change into a new format, you can type the multiple columns names separated by comma.

We have a feature that auto-detects your starting format. It will auto-detect the date format. Alternatively, you can use one of the preset formats available, also the custom format option is available, when selecting the custom option, add the format into "Starting format - Custom" field, date formatting is case-sensitive.

For the New Format field, you can either select from preset formats or type one by selecting custom option, then add the format into "New format - Custom" field, date formatting is case-sensitive.