This content has been marked as final. Show 2 replies
I have 3 tables:
1. EmpPresent Table contains below fields:
b. Date of Hire
2. EmpVacationDetails Table contains below fields:
3. PublicHolidays Table contains below fields:
I want the data in the below format and in 1 table. I am also fine if the output data is even date wise.:
d. Number of WeekDays
e. Number of WeekEnds
f. Number of Public Holidays
g. Number of Vacations
h. Number of Working Days
Number of Working Days = (Number of WeekDays) - (Number of Public Holidays + Number of Vacations)
What should be the best approach?
Feel free if you need sample data for the same or any inputs. Thanks in advance.