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.
Procedure
-
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:
- In the Current format field, select I
don't know, best guess.
- In the New format field, select
Other.
- In the Your format field, enter
dd/MM/yyyy.
The French format that you want to use, dd/MM/yyyy, is
not available by default so you need to enter it as a custom value in the
Your format field.
For example, this will change 12/25/2015 to 25/12/2015.
-
Click Submit to apply the function.
You have the possibility to output the result of this function in a new
column by selecting the Create new column check
box.
Results
The date format is changed in the selected column.