Friday, October 01, 2010

View of Employees Birthday in a SharePoint List

Suppose you have a corporate or divisional employee contact list containing birthdays and you need to show the employees whose birthday fall within the current month.

You have at your disposal the system variable [Today] but you can't apply a formula to this variable (such as =Month([Today])) to get the desired view with this month' birthdays.

What you can do is to add a calculated column of the date type. Then you can create a view filtered by this column. The idea is to fix the year to any year of your choice and compare dates accordingly.

Here is an example:

Let's say the column's name BirthDate and the year of choice is 2000, then the calculated date column would be:

=DATE("2000",MONTH(birthDate),DAY(birthDate))

1 comment:

  1. Nice tip. Thanks for sharing.
    zee
    walisystems.com

    ReplyDelete

Enter your comment here