As the date formats used across the world are not the same, you may need to change the format used in a column containing dates.
You will change the date format that is used in this dataset, from the American format, to the French format.
- Select the Entry_Date column.
- In the functions panel, on the right side of the screen, type Change Date Format and click the result to open the options for the associated function.
- Configure the function as follows.
The French format that you want to use, dd/MM/yyyy, is not available by defaut so you have to enter it as a custom value in the Your Format field.
For example, this will change 12/25/2015 to 25/12/2015.
- Point your mouse over the Submit button to preview the changes, and click it to apply the function.
The date format is changed in the selected column.