Get Year of CreatedBy date in a calculated column

sharepoint-2007 sharepoint-2013 calculated-columns
van picture van · Nov 12, 2010 · Viewed 22.3k times · Source

I am trying to create a calculated column in SharePoint 2007. I want it to return the year of the CreatedBy column date and set the day to be 1 and the month to be January the data type returned by the formula is of type Date.

Any ideas how I can do this? =YEAR([Created]) does not seem to work as expected.

Thanks Nav

Answer

Marek Grzenkowicz picture Marek Grzenkowicz · Nov 12, 2010

=DATE(YEAR([Created]),1,1)

alt text

Related questions

Sharepoint 2013 REST API not returning all items for a list

The title states my problem quite exactly. If I try to gather all 400+ items from a list using sharepoint's REST API, I only get first 100. I have read http://msdn.microsoft.com/en-us/library/office/dn292552(v=office.15).aspx and …

Read More
Get domain name

My computer is in a Domain (Active Directory) and I need to get the domain name dynamically. I found the following code on the internet: SelectQuery query = new SelectQuery("Win32_ComputerSystem"); using (ManagementObjectSearcher searcher = new ManagementObjectSearcher(query)) { foreach (ManagementObject mo …

Read More
How do I use the Sharepoint Web Service to get a list of documents from .NET?

Technologies: Winforms, .NET, C#, Sharepoint Web Services I'm currently writing a winform desktop application that is supposed to access a specific list of Sharepoint documents and custom input variables (From a Sharepoint Document Library) http://www.infoq.com/articles/swanson-moss-web-services …

Read More