show only the year field in Sharepoint date and time(Today) 

=CONCATENATE(YEAR([Created]))

https://stackoverflow.com/questions/19955643/how-to-show-only-the-year-field-in-sharepoint-date-and-timetoday

Comments

Post a Comment

Popular posts from this blog

How to Create an Auto-Incrementing Number Field in a SharePoint List

Auto-numbering is a common requirement when working with SharePoint lists. You may want an auto-incrementing number on Issues list items such as “ISS-001” and so on. If you try using calculated column with ID field and entered a formula such as = (“ISS-00” & [ID]), this won’t work for new items! The reason being ID field is filled ONLY after the item is created. Here are the steps to create an auto-incrementing number field in a SharePoint list designer workflow: Create a new column, such as :  Increment Number  in issue list with Number type. Make this column hidden in a view. Create another column, such as :  Issue No.  in issue list with Formula type and add the following formula = “ISS-00” & [ Increment Number ]. This Column will show the increment items’ numbers in the list. Open SharePoint designer, create new list workflow (for issues list). Add a workflow action: “Update list Item” >> Current Item >> Add >> Set thi...
Read more

SharePoint Integration with IIS

Image
Before discussing the Integration, we will discuss the architecture of SharePoint at the architecture level. The diagram represents the architecture of SharePoint and split into two halves. The Left-half is administrator world and the right-half is the end-user world. Everything in right half resides in SharePoint content database. Let's continue with some terminologies before goes into deep dive.  Farm A farm is a logical architecture or logical grouping of SharePoint servers that share common resources of SharePoint. It can be a single machine or more than one machine. The farm is differentiated on their tier levels. Might be possible Farm can be 1to N-tier. Installation can either be done at 1 machine to N. Most of the cases in production you have to choose at least 5-tier architecture for application Server, front-end  Server , SQL, AD+DNS, Office Web App Server and Exchange; you can add more than one application server, Front-End etc at any level. C...
Read more

How to add webPart to Page with PowerShell from WebPart Gallery

https://sharepoint.stackexchange.com/questions/233319/how-to-add-webpart-to-page-with-powershell-from-webpart-gallery #ensure that you use the site collection root url #if you use subsite url, will throw error since webpart gallery #exists only in the site collection root site $web = Get - SPWeb "https://site-collection-url" $pubWeb = [ Microsoft . SharePoint . Publishing . PublishingWeb ]:: GetPublishingWeb ( $web ) $publishingPage = $pubWeb . GetPublishingPage ( "https://site-collection-url/Pages/Test.aspx" ); $publishingPage . CheckOut (); $list = $web . Lists [ "Web Part Gallery" ] #use the webpart title or the .webpart file name $wpl = $list . Items | where { $_ . Title - eq "Your Webpart Name" } $xmlReader = New - Object System . Xml . XmlTextReader ( $wpl . File . OpenBinaryStream ()); $errorMsg = "" $wpManager = $publishingPage . ListItem . File . GetLimitedWebPartManager ([ S...
Read more