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.

Was this article helpful?
Cancel
Thank you!