I wanted to be able to show all of the employees birthday’s for the current day.  Turns out, this was not a very hard task to accomplish.  I have a field in one of my lists’ that contains a birth date field.  All of the months and days are accurate, but the years are all set to 1996 for security reasons.  In order to show upcoming birthdays, I needed to change a few things.

Here’s the deal with that.  The “Birthdate” field holds the actual birthday of the user.  In my case, 24-Jul-96.  However, I want to see it as July 24 2010.

Well, since the [Today] field in calculated column will not work (all tricks will not work – the field won’t update!), here is a solution that only asks for a yearly update to the column.

First, I created a calculated column that results in the current year “Birthdate”.  This changed the view of the date from 24-Jul-96 to July 24 2010.  Note:  “Birthdate” is the name of the column in my list that contains the actual birthday.  Yours may vary.

1. Create a calculated column to hold this year’s birth date named “Birthday”.
2. Set the output type of the calculated value to “Date and Time”.
3. Set the date and time format to “Date Only”.
4. Use this formula to generate its value.

=DATE(2010,MONTH(Birthdate),DAY(Birthdate))

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5.  Create a new view of the list named “Birthday” and click on the plus to expand “Filter”.

6.  Next, enter in the following.  Once you click Ok, you will see all birthdays for the upcoming week.

 

 

 

 

 

 

 

 

 

 

 

 

7.  If you only want to see the birthdays for the current day only, simply change the filter to the following.

 

 

 

 

 

 

 

 

 

 

 

 

 

Just remember – next year you will have to update the formula of the calculated column from 2010 to 2011.

Enjoy!