Set Date Field Friendly Display Format in SharePoint using CSOM

The example in this topic show how to use CSOM to Set Date Field Friendly Display Format in SharePoint

  • using Microsoft.SharePoint.Client;
  • using System.Linq;
  • using System.Xml.Linq;
  •  
  • using (ClientContext clientContext = new ClientContext("http://MyServer/sites/MySiteCollection"))
  • {
  • // clientcontext.Web.Lists.GetById - This option also can be used to get the list using List GUID
  • // This value is NOT List internal name
  • List targetList = clientcontext.Web.Lists.GetByTitle("List Name");
  •  
  • // Get field from list using internal name or display name
  • Field oField = targetList.Fields.GetByInternalNameOrTitle("Date column Name");
  •  
  • clientcontext.Load(oField);
  • clientcontext.ExecuteQuery();
  •  
  • string schemaxml = oField.SchemaXml.ToString();
  • XDocument xmldoc = XDocument.Parse(schemaxml);
  •  
  • // Option 1: Friendly display format = Relative
  • // When you enable this option, the date displayed will be "Relative" of what the value is entered(i.e - 5 mins ago, yesterday, etc..)
  • xmldoc.Element("Field").SetAttributeValue("FriendlyDisplayFormat", "Relative");
  •  
  • // Option 2: Friendly display format = Disabled
  • // When you enable this option, the date displayed will be in the actual format (i.e in dd/mm/yyy or mm/dd/yyy - based on your regional setting)
  • xmldoc.Element("Field").SetAttributeValue("FriendlyDisplayFormat", "Disabled");
  •  
  • oField.SchemaXml = xmldoc.ToString();
  • oField.Update();
  •  
  • clientcontext.ExecuteQuery();
  • }

Thank you for reading this article. This code was tested in SharePoint 2013


© 2019 Code SharePoint