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))
Friday, October 01, 2010
Subscribe to:
Post Comments (Atom)
Nice tip. Thanks for sharing.
ReplyDeletezee
walisystems.com