Articles on: Transforms

Format dates

The Find minimum by group step calculates the minimum value in a column or a group of columns. This step is similar to the MIN function in Excel.

Format dates



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.

Updated on: 20/09/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!