The easiest to way to list the birthdays of all Staff and Client is to group the birthdates based on Month. This can be achieved by a two-step process:
A. Create a new Calculated Column that results in current Month
- Create a new calculated column Birthday Month and set the type to String
- Use this formula to generate the Month of each Date of Birth
=TEXT([Date of Birth],"mmmm")
B. Create a new View to group all the birthdays based on Birthday Month
Only show birthdates for the next fortnight
Usually the Date of Birth field of Client/Staff holds the actual birthday (e.g. 12 March 1977, 12/03/1977), however to generate a list of birthdays, the birthdates need to be related to the current year (e.g. 12 March 2012).
This can be achieved by a two-step process:
A. Create a new Calculated Column that results in the current birthdate.
- Create a new calculated column ‘Birthday’ and set the type to 'Date and Time'
- Use this formula to generate a new birthday with the current year (e.g. 2012)
=DATE(2012, MONTH([Date of Birth]), DAY([Date of Birth])
B. Create a new View that filters all birthdates which are this week
- Birthday ‘is greater than or equal to’ [Today], AND
- Birthday ‘is less than or equal to’ [Today]+7
Now, you can see all birthdays for the upcoming week!
Just remember to update the current year as the year changes (e.g. 2012 to 2013 for next year).