Forum Discussion
Fill dates between two dates
I have a employee table with employee number,country, joined date and reasigned date as shown in the below image. There are employees from three countries. I'm also maintaining the working...
The requirements are not entirely clear. Could you please give an example of the output?
This is the expected outcome. dates column depicts the workingdays between joined date and resigned date. Inorder to get the workingdays of the employee, date table has to be checked for the workingdays for each country. Availibility is just a column with 1 value to make the visulization easir on a matrix