Sharepoint birthdays List on Codeplex
Today i have posted my first Codeplex project.
It 's a simple but useful feature.
It about showing birthdays on a Sharepoint (WSS & MOSS) Site
I based this list on a post
Here below there is the post I based my Sharepoint birthday List
As It didn't work as is, I decided to post it working on Codeplex.
_____________________________________________________________________________________
This web part is a very simple but handy part to show coming birthdays of people. You only use standard controls from SharePoint and you do not have to program anything. It also shows how to use some functions which are not directly available in calculated fields but can be used with a simple trick. so far as I know this trick be used for any other function which is not available for calculated fields. The following describes the steps to create this web part.
Choose "Manage Content" from the "Actions" menu. Choose "Create" and create a custom list. Choose "Modify settings and columns" and add the following columns:
Name, single line of text
Birthday, Date and Time
The Trick: You can not use the Today function directly from the calculated field. So we create a dummy column representing the Today function. The credits for this trick are going to Pete Blair.
Today, single line of text
Next we have to create two calculated fields. The first calculated field tranforms the day of birth to a date in the current year. This means that may 19th, 1971 will be may 19th, 2005.
BirthDayThisYear, Calculated, =TEXT(BirthDay,"M/D/")&TEXT(Today,"YYYY")
the second calculated field will calculate the number of days till that date.
BirthDayIsSoon, Calculated, =DATEDIF(Today,BirthDayThisYear,"d")
Now remove the Today column. The calculated fields will use the actual Today function in stead of the Today column. Make sure that whenever you want to change the calculated fields the Today column is created
Create a new view which will only show the columns Name and Birthday. In this view use the following filter settings showing only the birthdays in the next 14 days.