This query gives an overview of special events, for example, upcoming birthdays and anniversaries for all team members reporting to a particular manager. The query considers the Calendar month range and whether to include all employees directly or indirectly reporting to a manager. The query displays the upcoming events in a list view and in chronological order. The list includes the employee’s name, the event day, the employee’s new age, the organizational unit, and employee's manager.

This query runs for the maximum selection period of 1 year, that is, if the user enters a period of more than 1 year, the system considers the period as 1 year. For example, the user enters the following time period: January 01, 2011 to August 31, 2012 the time period is only considered for January 01, 2011 to December 31, 2011.

If an event happens after the date a person leaves the company, then that event date is not shown in the query output, even though that event date is within the selection period. For example, if the selection period is January 01, 2011 to December 31, 2011, and an employee leaves the company on the 01.04.2011 and their birthday is 01.06.2011 then that event is not shown in the query output.