Employees active in a given date

[Anonymous]

Hello everyone!

In my model I have a table called Employee with different employee data. In that table I've got the field START_DATE and END_DATE of the period worked by the employee. As for now I have two calendars, one linked with the Employee table by START_DATE and another one linked with the Employee table by END_DATE.

I would need to have some entity that allow me to see for each month how many employees are active.

For example:

If the date 10/06/2016 is selected the three employees should be active, if the date 25/06/2016 is selected 2 employees are active (Emp1 and Emp3). Emp3 should be active for dates selected from 23/02/2014.

¿How can I do this?

Thank you so much!

[MarcoWedel · Accepted solution]

one solution could be:

Creating Reference Dates for Intervals

hope this helps

regards

Marco

[Anonymous]

Thank you! This is exactly what I was looking for!