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.
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.
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.
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
Thank you!