{"id":22,"date":"2021-10-17T15:18:32","date_gmt":"2021-10-17T15:18:32","guid":{"rendered":"https:\/\/naderhadjebi.com\/blognh\/?p=22"},"modified":"2021-10-18T14:02:36","modified_gmt":"2021-10-18T14:02:36","slug":"reformatting-and-removing-time-from-date-column-with-json","status":"publish","type":"post","link":"https:\/\/naderhadjebi.com\/blognh\/2021\/10\/17\/reformatting-and-removing-time-from-date-column-with-json\/","title":{"rendered":"Formatting and removing time from SharePoint Online date column with JSON"},"content":{"rendered":"\n
\n
\n

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.<\/p>\n<\/div>\n<\/div>\n\n\n\n

\n
\n
\"step
STEP 1:<\/em><\/strong>
Select the column header>Column settings>Format this column <\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n
\"\"
STEP 2:<\/em><\/strong>
Select the column header>Column settings>Format this column <\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Step 3:<\/em><\/strong>
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”
]
}
}<\/figcaption><\/figure>\n\n\n\n
\n
<\/div>\n\n\n\n
<\/div>\n<\/div>\n\n\n\n

Check back for more SharePoint Online tips and also follow me on twitter @nader2015<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

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. Check back for more SharePoint Online tips and also follow me on twitter… Continue reading Formatting and removing time from SharePoint Online date column with JSON<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":28,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-22","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sharepoint","entry"],"jetpack_featured_media_url":"https:\/\/naderhadjebi.com\/blognh\/wp-content\/uploads\/2021\/10\/tip1step1-2.png","_links":{"self":[{"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":8,"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":65,"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/posts\/22\/revisions\/65"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/media\/28"}],"wp:attachment":[{"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/media?parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/categories?post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/naderhadjebi.com\/blognh\/wp-json\/wp\/v2\/tags?post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}