Monday, March 29, 2010

Show today's Birthday's and Anniversaries in Sharepoint

Is there any requirement that ask you to display the birthday of an Employee in your organisation. Are you thinking of developing a webpart and compare the date and display it in your homepage. Well that is not at all required if you have a Sharepoint Designer which is fortunately free to download. Lets build the task from the steps below

  1. lets say we have a column with the name DOB which stores the date of birth in datetime format.
  2. Create a computable column give it a name as DOBthisYear and add this "=TEXT(DOB,"M/D/")&TEXT(Today,"YYYY")" without first and last quotes :-)
  3. now lets view the list again where it shows the DOB for current year.
  4. Open the page in Designer and edit the page. Browse through the Datasource in the site and drag and drop the list to your place.
  5. Now it will add the powerful DataformWebpart. in a list view. Now add a filter to the list in the column DOBthisYear which equals [Current Date].
  6. Save the dataformwebpart give some formatting with the image of the employee to show up in the list.

No comments: