Displaying only Year in SharePoint Calculated Column

I wanted to display just the year of a DateTime column of SharePoint. I created a calculated column and set the formula to Year([MyDateTimeColumn]). The result I got was 2,009 ; 2,008 etc. which offcourse incorrect for year. After searching through internet, I found a good article solved my problem.

The correct formula is TEXT(YEAR([MyDateTimeColumn]),”000″)

SharePoint Foundation 2010 – What is it and What do you need to use it?

In the upcoming version of SharePoint i.e. SharePoint 2010, Windows SharePoint Services 3.0 has been evolved and got a new name called “SharePoint Foundation (SF)”. This will align it more to other Microsoft technologies like Windows Presentation Foundation (WPF) and Windows Communication Foundation (WCF).

SF extends the feature set offered by WSS 3.0 . It provides you a platform with right tools to build your collaborative web sites. Microsoft has published a paper to describe the business value of having SF 2010. You can read the paper here.

As expected, Microsoft has designed SF2010 for 64bit systems only. There is no 32 bit version of it. Following is the basic requirements list to install SF 2010 as described by Microsoft in the paper mentioned above:

SERVER ENVIRONMENT:

• Windows Server® 2008 64-bit operating system with SP2 or later, OR Windows Server 2008 R2 64-bit
• Microsoft SQL Server® 2005 64-bit with SP2, SQL Server 2005 Express 64-bit, SQL Server 2008 64-bit or SQL Server 2008 Express 64-bit
• Microsoft .NET Framework 3.5 with SP1 installed

CLIENT ENVIRONMENT:

Level 1 Internet browser options for Windows:

• Windows Internet Explorer® 7 32-bit
• Windows Internet Explorer 8 32-bit
• Firefox 3.x 32-bit

Level 2 Internet browser options:

• Windows Internet Explorer 7 64-bit
• Windows Internet Explorer 8 64-bit
• Firefox 3.x on non-Windows operating system
• Safari 3.x