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

[disqr_rm]

A simple intervalmatch() should do the job for you. See enclosed.