select Date from 2 filed to retrieve data?

[#1]

Hi all,

i have table contain date for Start date & End date for vacation, i need to retrieve sum of employee start vacation and the employee End vacation on specific date range or month from specific year.

All Employee start vacation on 2/2010 = 10

all employee end vacation on 2/2010 = 12

maybe some of employee start them vacation on 1/2010 but end on 2/2010 , it's will show on result.

maybe some of employee start them vacation on 2/2010 but end on 3/2010 , it's will show on result.

any idea ??

thanks on advance

[#2]

Hi there, I think you can accomplish this using set analysis, so if understand correctly you expression should look something like this:

count( {$<EmployeeID = P({$<StartDate = SelectedDate>}) + P({$<EndDate = SelectedDate>}) >} EmployeeID)

That should do the trick. Notice that it will only works on version 9.

Regards.