Emp DOJ DOR
10 1-Apr-2012 13-June-2014
11 11-Apr-2013 15-Apr-2014
113 12-Apr-2011
16 11-Nov-2014
12 14-Aug-2013 13-Nov-2014
I have an employee table information.I want employee count based on Day Selection.
Suppose if i have selected 15-Apr-2014 then all the employee count should come (employee count -5)
If I have selected 16-Apr-2014 then we need to exclude Employee ID 12 from the employee count (Emp count 4)
Because 15-Apr-2014 is last day for that employee so next day he should not come in the emplyee count.
Please anyone help me to give solution..Urgent help required.