Formatting and removing time from SharePoint Online date column with JSON

Reformatting and removing time from date column with JSON
Formatting and removing time from date column with JSON

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
STEP 1:
Select the column header>Column settings>Format this column
STEP 2:
Select the column header>Column settings>Format this column
Step 3:
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

Leave a comment

Your email address will not be published. Required fields are marked *