Here’s an example of a text version of the instructions: Remove time and put the date in a friendlier format 1: Select the column header>Column settings>Format this column 2: Select advanced mode 3: Enter the following JSON. Select preview and then save.
![step 1 - format column](https://naderhadjebi.com/blognh/wp-content/uploads/2021/10/tip1step2-1.png)
Select the column header>Column settings>Format this column
![](https://naderhadjebi.com/blognh/wp-content/uploads/2021/10/ts2-1.png)
Select the column header>Column settings>Format this column
![](https://naderhadjebi.com/blognh/wp-content/uploads/2021/10/ts32021-10-17_16-18-44-1-1024x560.png)
Enter the following JSON. Select preview and then save.
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“txtContent”: {
“operator”: “toLocaleDateString()”,
“operands”: [
“@currentField”
]
}
}
Check back for more SharePoint Online tips and also follow me on twitter @nader2015